I am working on a aircraft Parts management database. I am trying to find a
way to relate or link Major assembly components, Sub assembly components, and
components. For example all parts, assemblies, and sub assemblies are listed
in the tbl_partnumbers they have corresponding records in tbl_serialnumbers
that also refer to a record in tbl_locations I want to be able to view a
major-assembly record that will also list all sub-assembies and the parts
those sub-assemblies contain. I also want to be able to move a sub-assembly
from one Major-Assembly to another and have all of its parts Follow it. Or
move a major-assembly between aircraft and have all sub-assemblies and parts
follow. maybe this can be done by somehow associating the locations, but i am
stumped for now..