Multiple relationships pulled into one table

  • 1
  • 1
  • Question
  • Updated 4 years ago
  • Answered

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.

Example:

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?

Photo of Sophia Benfield

Sophia Benfield

  • 0 Points

Posted 5 years ago

  • 1
  • 1
Photo of Jared

Jared

  • 0 Points
Hi Sophia,

You would want to create a "Joining" table and a "Location" table to set this up. Here are what the relationships should look like:

Applicator Type --< Joining table

Chemical Type --< Joining Table

Chemical Inv. --< Joining Table

Locations --< Joining Table



You would Create records in the Joining table as needed and associate them with the location table.
Photo of Hizuru

Hizuru

  • 10 Points
Hi - I'm interested in this solution. Is there an example app that shows this model in use?