Access 2007
Main Form:
frmEquipment
Table:
tblEquipment
Fields:
EquipmentID(primarykey)
WMI
EquipmentTypeID(foreignkey)
Mfr
Mdl
SN
Subform 1: (Datasheet view)
tblfrmComponent
Table:
tblComponent
Fields:
ComponentID(primarykey)
EquipmentID(foreignkey)
ComponentName
ComponentTypeID(foreignkey)
Mfr
Mdl
SN
Subform 2: (Datasheet view)
tblfrmFilter
Table:
tblFilter
Fields:
FilterID(primarykey)
ComponentID(foreignkey)
Type
Mfr
Mdl
SN
The issue is what is the proper database way of getting all the filters for each ComponentID to show up for all ComponentID's with the same EquipmentID. Should I include an EquipmentID in the filters table? The reason for the datasheet views are so that someone can see what is equipped and if anything is missing there are buttons to click to add. Primary keys and foreign keys are one to many.