Adding child fields to a parent record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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 have many material categories)

In the Vendor form there's an embedded report that shows all of the material categories that have been assigned to the vendor.

I'd like a way to search the Vendor table for the particular category. Is there a way for the parent table to look down to the child for the categories, and have that field be searchable on the parent table?

I'd like the users to be able to enter "wire" on the Vendor Table search report, and get a list of vendors with the wire category assigned to it. 
Photo of Ashley Asante

Ashley Asante

  • 786 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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.