Each record in the schedule links to how many equipment lists? Sounds like you need a table with one record for each equipment list linked to another table with one item of equipment for each piece of equipment on a given list that in turn links to your inventory table (master equipment list if you will).
It needs to link to one or all equipment lists that are related to the "event" record. for the example the main room schedule might need to reference a Audio, video and lighting equipment list.
my "line items" table has an equipment list ID number. I wanted to try to link the relate the schedule::equipment lists field to the Line items:: equipment list ID field, but that makes a many to many relationship and it only displays the line items associated with the first list id in the schedule::equipment list field.
Each "scheduled" equipment list needs to be a distinctly different set of records each time you schedule it.
Schedule::__pkScheduleID = EquipmentLIst::_fkScheduleID
EquipmentList::__pkEquipmentListID = LineItems::_fkEquipmentLsitID
Inventory::__pkEquipmentID = LineItems::_fkEquipmentID
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained