Seeking Suggestion

[Martin]

I have developed a database where I need to track the equipment in each room
of a building. Since some equipment do repeat (Manufacturer and Model) the
database has a Master Equipment Table where the detailed information of the
equipment is stored (Manuf, Model, electrical, etc).
When populating the room with equipment, a have a separate table where the
RoomID and the EquipID is stored along with distinct information related to
each equipment in the room (like Serial Number, ID Tag).
In general, everything is working as planned. The only situation that has
presented that I am looking for suggestions and/or ideas, is how to handle
when two or more pieces of equipment need to be together. For example, a
Equip01 comes with a Computer and a monitor. However, the Computer is listed
as Equip02 and the Monitor as Equip03.
I was thinking about creating another table where I could store the
associations. For example, at the selection of Equip01, I have a subform
where I select the equipment that goes together with it. However, there might
be some limitations associated with this idea:
1. When populating the Room with equipment, is it possible to pull the
associated equipment automatically in my list? If so, where can I find
examples.
2. If not possible, how can the user be alerted that additional equipment
needs to be added when Equip01 is selected?

Your suggestions will be appreciated.

Martin

 

[KARL DEWEY]

RoomID and the EquipID is stored along with distinct information related to
each equipment in the room (like Serial Number, ID Tag).
Your master equipment table should have the Serial Number, ID Tag and not in
the junction table for RoomID and the EquipID.Why not just one more field in the master that signifies it is standalone,
must have ancilliary, or is ancillary equipment.The query for the subform listbox or combobox would have criteria of
ancillary equipment.The main form include the field to display 'must have ancilliary equipment.'