Design to keep relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top