How to create sub-accounts in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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."
 
Back
Top