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