Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
2 years ago

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
------------------------------
Relationships

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      2 years ago

      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
      ------------------------------