append new records

[tina]

Hi
I have a table with field code supplier manufacturer etc
the code is unique in this table but supplier or manufacturer for code can
change
i would like to keep code history in separate table where code would not be
unique but show all suppliers or manufactures ever used
so when supplier or manufacturer changes i would like to append record to
new table
what is best way to do this?
Thanks
Tina

 

[Van T. Dinh]

It sounds like you need to modify your database to model the Many-to-Many
realtionship between Codes and Suppliers. The same for Codes and
Manufacturers.

Check Access Help / your Access book(s) on the Many-to-Many realtionship.