Expand all | Collapse all

Adding child fields to a parent record

  • 1.  Adding child fields to a parent record

    Posted 04-26-2018 16:31
    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. 

  • 2.  RE: Adding child fields to a parent record

    Posted 04-27-2018 08:22
    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.