If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Grouping components and updating locations
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.. |
Thread Tools | |
Display Modes | |
|
|