Adding child fields to a parent record
I have a Vendor Table (Vendor Name, Address, Phone, etc). I also have a Material Category Table (Wire, Cable, Fittings) The Vendor table is a parent to the Material Category Table ( a vendor can h...
Forum Discussion
Ashley,
I suggest building your search on the "Join" table where you have the Vendor Material Assignments, instead of searching in the Vendor table itself.
Presumably you have set up a relationship where 1 vendor has many Vendor Material Assignments and 1 Material has many Vendor Material Assignments.
I suggest building your search on the "Join" table where you have the Vendor Material Assignments, instead of searching in the Vendor table itself.
Presumably you have set up a relationship where 1 vendor has many Vendor Material Assignments and 1 Material has many Vendor Material Assignments.