Recent content by LukeMatt

Once again, thank you everyone for your replies. I now understand referential integrity in Access...but I don't necessarily like it. :eek: 1. For most of my linked tables, I followed gemma-the-husky's advice: It's logical, but I didn't come up with the idea myself because I thought, "Why...

Thank you for your many responses. An archaeology researcher has a database that contains a table with one record for each X artifact that she has found. That's Database A. She has another database that contains a table with one record for each Y artifact that she has found. That's Database...

Although I feel very comfortable with Access, I still cannot figure out one of its most fundamental aspects. :( I have Database A and Database B. They both need to use a lookup table that contains valid locations. I have put this lookup table in Database C. In Database A and Database B, I...