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

Qrew Legend

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

Qrew Assistant Captain

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

Forum Discussion

How can I use the data from a parent table to populate multiple fields of the same type?