I have 3 tables Seats, Hardware, HardwareAtSeat HardwareAtSeat has columns ID,SeatID, HardwareID, and active ID the key for the HardwareAtSeat table SeatID is a reference to the Seats table HardwareID is a reference to the Hardware table Active is a ...