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?
Hi.
(at first I said yes, but I thought about it a bit).
You probably need a value list picker based on the join table. This value list probably needs to be based on a relationship to the join table from the sales table. Maybe your sales table contains fields that hold a certain vendor, and you want to see that vendor's products in the join table.
So Yes, is what I think, but make it a pick list that is based on a special relationship to the join table (vendor or product).