How to create sub-accounts in Access

[Dave S]

Hi Everyone:

We have a need to create a primary account with subsequent child accounts
underneath. For instance: Main Heading: Computers, a sub account would be
Hardware, a sub account would be Modems, a sub account would be 3Com, and so
forth. For some reason, I am totally drawing a blank on how to do
this--obviously, creating a table for each sub account seems incorrect.

Thanks

 

[Bob M via AccessMonster.com]

If you want to list all the hardware that each computer has in it then you'll
need three tables
In your Main table you would have:
ComputerID (PK)
Computer
(any additional info such as date of purchase, Serial Number, etc.)

Another table with:
HardwareType (Modem, Video board, etc.)

The third table would be for all the hardware in a computer:
ComputerID (FK)
HardwareType
HardwareName

In the entry form based on the Main table you would place a subform
(continuous), linked to the Main table by ComputerID, based on the third
table. Use a Comb Box to select the Hardware type in the subform.
You can then enter a computer and list all the components you want.
I hope this gets you past your "blank."