Emily has attended:
Access Introduction course
A table within a table
Hi
Could you tell me whether it is possible to add a table within a table. Being able to click on certain fields and open up new information on that particular field.
I have been working on a table like that for some time but did not create it myself so am struggling to know how!
Thanks
RE: 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
RE: A table within a table
Hi David
Thanks for this, i've worked out that if I play around for long enough I can work it out and I have managed to link my tables.
I have another question now! I have created some drop down menu's on a number of my fields in my table. From one of the fields once I select one of the drop down items on the menu I would only like to view certain drop down menu for a couple of the other fields. I have been told this is possible but don't know how to do it. There are 3 different selections of drop down menu's that I would like.
Hope this is clear but am struggling to explain exactly what I want to do.
Thanks,
Emily
