basenine 3/25/2015 12:40:53 PM
Have done this by creating a new table called Historical Price. Every time the price changes in the Parent table, it creates a new record in the Historical Price table via a workflow trigger...when record is added or modified...in column Buy Price...create new record in Historical Price. Push through the Parent table id , the price etc into the new (related) record
The most recent price is now pushed through to the new record and is also held in the parent record for use in your other tables.
You can set up a Custom Button with Mass select function to go through all of your current materials/inventory and create the first Historical Price record. Every time you create a new parent record, it will also create a new historical price record.
Hope this helps