Hi,
I am developing an application which i need to maintain data for customers in different tables in Access database. The field i use: PartID, PartyName, Receiving Amount Date, Amount Received etc...
Now i want to save the same data in other table too. I don't make any primary or foreign key in my table, PartyID is unique, once the ParttID has been assigned to the customers it will never be assigned to other party as wel.