Get data from an unrelated table
I have a QuickBase and I have three tables involved.
- DSO
- TINS
- Contacts
The Tins and the contacts table are related to the DSO table using the Field DSO name.
What I need to do is pull in some contact fields into the Tins table.
How would I set up the relationship in order to do this?
Thanks.
OK, np,
Create a field called [Contact for Rollup] on the Contracts table which combines the fields you want to retrieve. For example
List(" ", [Name],[ Email],Phone])
Use a Combined Text Summary field on the relationship between DSO and Contacts to roll these up to the Parent DSO. Accept the suggested name for the field. Filter on Primary.
Make a formula field on the DSO
SearchAndReplace(ToText(Combined Text Contact for Roll up])," ; ", " \n")
Look that field up down to TINS.