Design to keep relationships

[Guest]

I set up a query with one data table and 10 lookup tables to change numbers
to names. How do I put new data in the data table and keep the relationships
to run the query again. When I copy the new data to the data table and go to
the query, the relationships are gone even though the data table has the same
name.
Thanks

 

[Douglas J. Steele]

Lookup fields in tables is generally considered to be a bad thing (see
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some of
the reasons why).

Create a query that joins your 11 tables together. Even if you delete the
data table and recreate it, the query will continue to work.