Copy Data From 1 Table To Another

[RockyAndNickels]

I have two tables: one table (called basic info) to enter the basic information (lets say someone's name, telephone number, and their address) and a second (called extended info) to enter more information (say their car info, work information, movie preferences, etc.).

I want to have the name care over from the basic info table to the extended info. How would I do this?

 

[John Big Booty]

You could do it with a form and sub form set. You will need two tables, one called, say, TBL_Names, that would store NameID (auto Number, Primary Key {PK}) along with all the other info you want in that table. The other you might call, TBL_NameDtl, this would store NameID (as a foreigh Key {FK}) along with all the other info you wish it to store.

Now you create your main form and bind it to TBL_Name, then in that form you insert a sub form which will be bound to TBL_NameDtl, the link between those two forms will be NameID.

Once you've got that set up all the additioanl data that is input in the sub form will be automajically linked to the data in your main form.