AutoLookup

[Guest]

Although this should be easy, I cannot get it to work - please let me know
how to have data (names) automatically be input from one table to another.

Thank you.

 

[Joseph Meehan]

Although this should be easy, I cannot get it to work - please let me know
how to have data (names) automatically be input from one table to another.

Thank you.

Make table or update query.

 

[John Vinson]

Although this should be easy, I cannot get it to work - please let me know
how to have data (names) automatically be input from one table to another.

Why would you ever WANT to do so?

The whole *point* of a relational database is to avoid redundancy,
thereby avoiding redundancy. You should store names once AND ONCE
ONLY.

If you need a name in conjunction with data in another table, store
the name table's Primary Key field as a foreign key in the other table
(for instance by using a Form based on the names table and a Subform
based on the other table, using the ID as the master/child link
field).

You can then create a Query joining the two tables to display the name
from the names table, and the other data from the other table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps