Hi All, thanks in advance
I maintain military equipment with inspections coming up requiring printed forms.
tblPersonnel
tblEquipment
tblComponents
tblInspections
tblCatalog
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
PersonID 1
has equipments 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, for components and inspections, which is a bummer and besides the point of a database.
Any Ideas? Missing keys, relationships?
https://goo.gl/photos/RtWK8yz8ufR38Ahr7
https://goo.gl/photos/32zGxUi3ojsrso7a9
I maintain military equipment with inspections coming up requiring printed forms.
tblPersonnel
tblEquipment
tblComponents
tblInspections
tblCatalog
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
PersonID 1
has equipments 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, for components and inspections, which is a bummer and besides the point of a database.
Any Ideas? Missing keys, relationships?
https://goo.gl/photos/RtWK8yz8ufR38Ahr7
https://goo.gl/photos/32zGxUi3ojsrso7a9