Hi All, thanks in advance
I maintain military equipment with inspections coming up requiring printed forms.
One person has many equipment. Each one (tblequipment)equipment has many (tblInspections)
has many (tblComponents)
tblCatalog is simply a reference pick list, that holds part numbers to describe the components and equipment (price, location, ect)
What is getting me is trying to pass information through subforms
has equipements ID 18, 19, 20
each has inspections
it's passing personID beautifully through all forms/relationships, but I'm having to manually enter the EquipmentID, which is a bummer and besides the point of a database.
Any Ideas? Missing keys, relationships?