Maintain price update history

[renev]

I have a database to maintain bill of materials where it contin part description, price etc .There can be price update for each part. How can i maintain price update history. Also i want to display this price history in a portal which is view only purpose.

Anyone please guide me on this issue?

[Ocean West]

How "detailed" do you need to be?

You could use the method of capturing the data into a single field as an audit log.

http://www.filemakermagazine.com/videos/super-audit-logging.html

http://www.nightwing.com.au/FileMaker/demos7/demo702.html

[renev]

Thanks for the response.But i feel the solution is little complex.

In my case, user can update only the price of the part, rest all fields are non updateable.

Is there any way to create a history table and when the user updates the price of the item part_id, price(old) and date(old) are saved in the history table. There can be price update more than once, so those many records will be kept in the history.

Appreciating your help.

[mr_vodka]

Perhaps you should just script your updates to the product prices to create new records. then your relationship can sort in descending order ( or desc by creation date if you wish ) so that the most current price will always be used for each product when referencing the table occurrence.