AnsweredAssumed Answered

Inventory Product with multiple vendors

Question asked by moderndesigns9 on Jan 20, 2019
Latest reply on Jan 20, 2019 by moderndesigns9


Okay, so I am making a Database for a steel company and running into a roadblock and don't really understand where to go from here!

 

Current Tables

"Clients"

"Sales"

"Products"

"Vendor"

"Join Table For Products and Vendors"

 

So I am able to create multiple products

 

and also able to create multiple vendors

 

and with my join table, I am able to assign multiple vendors to one specific product! Great so far!

 

 

Now when on my Sales Layout I need to select one of the products to sell to a Client

 

do I create a table occurrence  of the "Join table"  and relate it to my Sales Table

 

or do i need another type of table to grab data from the Join table of Products and Vendors?

Outcomes