Access table design

[Keith Davis]

How do you get one field in a table to link to another
field? I have an IDNO field in a table that is entered
into the record by using a lookup from another table. I
am interested in having this lookup bring in more than
just the one field (IDNO) into this table. I would also
like the NAME associated with the IDNO to be entered into
the same record. How would I do this?

Thanks in advance!

 

[DDM]

Keith, you don't really want to do this. Believe me, you don't. There's no
point in duplicating information like that (by bringing in more than just
the one field). Instead, what you want to do is build a query based on the
two tables. Join them on the IDNO field. Include all the fields from the one
table, and the NAME field (plus any others you may need) from the other one.
Run the query. The result is a virtual table that combines the fields from
the two actual ones as if it were a real table itself. You can even update
it. Enter an IDNO, for example, and the NAME that goes with it will appear
right along with it.