Can you create a relationship in Access (2003) from one table to many different tables?
Basically, my database is our member's information.
My other tables are the member's inventory.
The way I have set it up is each table is a different kind of inventory (they are very large). Example: Computer inventory, cell phone inventory, car inventory, etc...
What I want to do is create a relationship using their member #... so when you open the member information database, you can click the + sign and see all of that member's inventory.
Is there a way to do this and did that make any sense at all? I've been staring at this screen for hours and it is driving me nuts.
I know that there has to be a computer "guru" out there who knows exactly what I am talking about!
Thanks so much for all of your help!!!!