Insert to another table

[TimjHebert]

i have 2 tables ?(table1 and table2) In table1 i have Customer,Contact,address etc. in table2 i have the same fields with an additional field called rig. I want to use a form with a combo box to autofill the customer info and on that same form have the additional field (rig) manual input. then once the fields are filled and the rig manually input copy this data to table2. how can i do this?

Thanks,
Tim

 

[trucktime]

Tables

Why have 2 tables? If you copy data from one table to another you create redundant data which violates the rules of database normalization.

 

[Pat Hartman]

The only field that needs to be stored in the Rig table is the one that identifies the customer. Then you can use a query to join the rig and customer tables and select whatever data you need from each table.

 

[TimjHebert]

insert into another table

I will be using table1 as a reference table only. My form will use this table just to pull up the customers with a combo box.

Thanks,
Tim

 

[trucktime]

You can pull up the customer from the main table with a combox box and use the bookmark method. You don't need a second table.

 

[TimjHebert]

insert into another table

Excuse my question, i am new to access. what is the bookmark method?

Thanks,
Tim

 

[trucktime]

Bookmark

Tim,

here is a little sample database I made for you.
Look at the form in design view, the code in the After Update Event
of the Combo Box. That is where it happens.

Good Luck and Happy New Year.