Boo. A disheartening answer, but I appreciate it. I'll explore the links you've provided to see if I can find a better approach to the issue.

Thanks.

I'm a relative newbie to Access, working in 2003 and trying to build a very simple client database for my company. Here's the basic set-up I have so far:

-Clients Table contains all the relevant contact info for all clients. Name, address, email, contact person, etc.
-Orders Table contains each order the various clients have made, including dates, quantities, etc.

The Orders table contains a Client ID field...