Linking fields

[keef2008]

I have two tables, table1 and table2.

table1 contains a list of names and numbers, in two fields.

table2 contains details jobs against names and numbers, the names and number
fields will be linked to the corresponding fields in table1. I want to link
the names and number feilds in table2 - so that when you select a name in
table2 the associated number from the same record in table 1 is
selected...and visa versa if possible...i'm very much a novice and dont know
how to do this.

 

[keef2008]

Sorry - i'll re-explain....

I have one table containing just site names and site codes. table1

I have another table containing specific details for a job. table2

I have one form for entering jobs.

Each time i add a new job record using the job form i want to be able to
select the site name using a combo box, then i want the site code to it to
automatically appear.

Alternatively - if i select the site code, the site name should
automatically appear.

I've been hunting about and found some threads that explain using queries to
do this, but i cant get it to work...

I'm sure it is simple though......