table design

[habbabub]

if i had a table with products and i want to keep a record of what has been chaged or added to this product, whilst keeping the old records how could i set it up in a databse?


the excel spread sheet looks like this



product commments

1 chnged this and that 20/08
1 modifyed component 21/08

2 newest model 3/08

 

[WayneRyan]

H,

Use the search facility here and look for "Audit Trail".

It's a pretty common topic.

Wayne