Quickbase Discussions

I am trying to correct one of the design issues with an app I inherited.  The original design did not contain a contacts table.  As a result I have several fields in tables that are storing name, email and phone data.  I created a Contacts table and a relationship to the Master table with the Contacts as the parent.  But I cannot see how to use the data in the Contacts table to populate multiple sets of contact related fields.  

I look forward to your suggestions.

------------------------------
Paul Peterson
------------------------------

You basically have two choices.
One choice is to have multiple Relationships.

So for example a field for Client Main Contact with where the relationship is [Related Main Client Contact].
Then duplicate that field which will conveniently duplicate the relationship and give you a new relationship for [Related  Secondary Client Contact].

  Be sure to set a correct "Proxy" field for each contact.

The other alternative is to have a many to many join table called say Project Contacts.  One Project has Many Project Contacts and One Contact is used on many Project Contacts. 

The Project will have an embedded child table of Project Contacts.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 06-22-2022 14:03
From: Paul Peterson
Subject: How can I use the data from a parent table to populate multiple fields of the same type?

I am trying to correct one of the design issues with an app I inherited.  The original design did not contain a contacts table.  As a result I have several fields in tables that are storing name, email and phone data.  I created a Contacts table and a relationship to the Master table with the Contacts as the parent.  But I cannot see how to use the data in the Contacts table to populate multiple sets of contact related fields.  

I look forward to your suggestions.

------------------------------
Paul Peterson
------------------------------

Thank you Mark!

I used the first approach once before with the contacts table and thought there had to be a better way.  The embedded report is not an option as I will need to use the data in other fields as well.  

------------------------------
Paul Peterson
------------------------------

Original Message:
Sent: 06-22-2022 20:19
From: Mark Shnier (YQC)
Subject: How can I use the data from a parent table to populate multiple fields of the same type?

You basically have two choices.
One choice is to have multiple Relationships.

So for example a field for Client Main Contact with where the relationship is [Related Main Client Contact].
Then duplicate that field which will conveniently duplicate the relationship and give you a new relationship for [Related  Secondary Client Contact].

  Be sure to set a correct "Proxy" field for each contact.

The other alternative is to have a many to many join table called say Project Contacts.  One Project has Many Project Contacts and One Contact is used on many Project Contacts. 

The Project will have an embedded child table of Project Contacts.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com

Original Message:
Sent: 06-22-2022 14:03
From: Paul Peterson
Subject: How can I use the data from a parent table to populate multiple fields of the same type?

I am trying to correct one of the design issues with an app I inherited.  The original design did not contain a contacts table.  As a result I have several fields in tables that are storing name, email and phone data.  I created a Contacts table and a relationship to the Master table with the Contacts as the parent.  But I cannot see how to use the data in the Contacts table to populate multiple sets of contact related fields.  

I look forward to your suggestions.

------------------------------
Paul Peterson
------------------------------