Subform 2: (Datasheet view)
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.