Getting Started

[Guest]

Please forgive my ignorance, I'm very new to Access....here's my question:

Say for example I have a table for System of some kind, that table contains
a field for the number of sub-systems contained in the "master" system. For
this example I'll say the system contains three subsystems.

When data entry occurs I want the user to be able to identify parts for each
sub-system. So they would select the master system, then would have the
opportunity to select sub-system 1, 2, or 3 (based on the # of sub-systems
defined above).

But if I'm using another master system that only contains 2 sub-systems I
only want them to be able to select sub-system 1 or 2.

Did I make this clear as mud? How could I go about doing this?

 

[Guest]

You need at least three tables. Systems, Subsystems, and SubSysParts. They
need to be in a one-to-many relationship with the 'one' side having a primary
key (usually autonumber) and 'many side having a foreign key field that is a
number - integer to match the primary key.
Use form/subform.sub-subform that are Master/Child linked in SystemsID and
SubsystemsID.