Forum Discussion
Tom_Masiello
May 23, 2024Copper Contributor
Contacts related to Organizations, Schools, and Employers in Microsoft for Non-Profit
One of the requests from a client is to relate Contacts to an Employer, School, and/or Organizations. We are debating between using stand-alone custom table(s) or just the OOTB Account table. We know...
alex_kasavin_msft
Microsoft
May 24, 2024Hi Tom - if a client needs a Contact to have one-to-many relationships with Accounts, extending the choices in the Account table may not be the best option because you'll be constrained by the one-to-one relationship there.
While a custom table is certainly an option, I recommend looking at the Connection table for the custom relationships. It's designed to support multiple roles that a contact may have across organizations.
While a custom table is certainly an option, I recommend looking at the Connection table for the custom relationships. It's designed to support multiple roles that a contact may have across organizations.