Professor Rost,

I studied your videos on Many to Many relationships and I understand how those relationships work in an Access database.   My problem is, Im creating a Landscapers database that needs to have Many - Many to Many Relationships, and Im at a loss to know where to start.

My database contains a table of Persons with types for Customers, Employees, Vendors, and Subcontractors; It also has tables for Assets, Supplies, and Consumables.   The issue Im having is I need to create Work Orders.  And each Work Order must contain references to multiple Employees (and possibly subcontractors), multiple Assets (like mowers, trucks, backpack blowers, etc.), multiple Supplies (like grass seed, fertilizer, mulch, etc.). and multiple consumables (like oils, grease, gasoline, diesel fuel, etc.).   The database must allow the operator to schedule multiple Work Orders by selecting multiple records from each of these other tables.   And once selected to a specific Work Order those records (people, assets, supplies and consumables) become unavailable for use in other Work Orders that would clash on the same scheduled days.

Creating the initial multiple, many to many table relationships is where Im getting stuck.   Any help is greatly appreciated.

Gay James