Adding child fields to a parent record

  • 0
  • 1
  • Question
  • Updated 7 months 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

  • 696 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
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.