For an example, open the Northwind sample database that comes with Access.
Then open the Relationships window (Tools menu) to see how the tables fit
together.
An interesting example is the Orders and Order Details tables. One order can
have many line items, so the lines for the order are in the Order Details
table.
for some tutorials on how to get into the relational mindset. It can
be a steep learning curve but you'll find it very powerful when you
get into it!
John W. Vinson[MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.