Adding child fields to a parent record

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

  • 736 Points 500 badge 2x thumb

Posted 12 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 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.