Forum Discussion

Axsess_EnergyGr's avatar
Axsess_EnergyGr
Qrew Cadet
7 years ago

Pull data from multiple child records into one parent record

I have a parent table called Supplier and child table called Supplier Contacts.  Each Supplier can have multiple Supplier Contacts.  I would like to list multiple Supplier Contacts on the Supplier ...
Relationships
Tables and fields
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
It's only a problem if your process requires information from more than one field be concatenated into one field at the parent record.

If you're concatenating multiple values in the SAME field, there's a new native summary field type that will do that.

If you only need visibility to all child records, an embedded report (on [Related Supplier]) will do that easily.