I am working on a training application that can be used for all 5 of our locations. I have a table for Chemical Type, Applicator Type, and Chemical Inventory. What I want to do is take this information and assign it to a location.
Chemical Type: Hot Wax, Presoak, etc.... Each of these are their own record with detailed training information.
Applicator Type: Elephant Ear, Foamer, CTA, etc....Each of these are their own record with pictures of the equipment that applies the chemical type.
Chemical Inventory: Simoniz Hot Wax, Gorilla Hot Wax, TV Presoak, etc....Each of these are their own record with detailed training information.
The relationship between them is many to many across all three. Each chemical type can have many applicator types and many chemical inventory. Each applicator type can have many chemical types and many chemical inventory. Each chemical inventory can have many chemical type and many applicator types.
The next step is where I am stuck. I want to assign each of these to a location and be able to have the specific training details show up in one location.
Example: Location A uses Hot Wax that is applied with an Elephant Ear and the specific chemical used is Gorilla Hot Wax. Location B uses Hot Wax that is applied with a foamer and the specific chemical used is Simoniz. Location C may not use Hot Wax at all.
Any ideas on how to make that happen?