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
