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, ema...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
    ------------------------------