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?

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

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.

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.