Vehicle to Equipment

[SliferTheSkyDgn]

I'm creating an access database for tracking what vehicle has what different tracked equipment it has installed. I have a table for the vehicles and their admin info, and then separate tables for the different kinds of equipment that could be installed and interchanged between the vehicles. How do I go about associating a vehicle with the various equipment? The end result is I want to be able to uncheck field box in the equipment table that indicates that the equipment is not functional that then indicates to the vehicle that it is installed in that the vehicle is not fully operational.

[ranman256]

I would think you only need 1 table for equipment.
it would have the VehID of the current place its installed.
and the Maintenance table to track where things went.

tEquip table:
EqID, eqProdMake, model , eqType, serial, VehID, EqStatus
555, Sony , CD123, CD player, 12345, 987, working

tVehicle table:
VehID, Make , Model, VIN,
987, Chevy , S10, 123345

tMaint table:

VehID, EquipID, InstallDate,etc
987, 555, 1/1/2019, installed by Bob

when the tEquip.VehID = null, then it is not installed in any car and should be in the stockroom.

[SliferTheSkyDgn]

What if one of the equipment items let's say a GPS tracking system consists of multiple SN sub parts, that can be interchangeable between GPS systems to make complete system could still be managed by one equipment table?