access+database+training - A table within a table

Hi Emily

I would create two separate tables, then create a relationship between the two. This is the easiest way of achieving what you want within access. It is possible to create nested tables within databases, but with access I would stick to creating two separate tables.
You will need to create a unique ID in table 1 and use this same ID within table 2, so that you can create a relationship.

To create a relationship between two tables you need to go to the menu, go to tools, click relationships. That will open a new window, add both the tables to the relationship window. Click the unique ID in table 1 and drag this to the identical field in table 2.

Hope this helps

David