79
Hi all,
Just a simple question: can I create a N:1 relationship between Products and Contacts?
I would like to add products that Contacts express interest on, so I can target them with specific campaigns.
Hi barbieruelas,
Agree with Andrew.
I would recommend you create N:N relationship instead of 1:N.
If you create a N:1 relationship, then each product will have a lookup field of contact, and one lookup field can store only one record. In other words, only one contact can be associated with a product.
In actual business, a product is associated with multiple contacts. So we should create an N:N relationship.
Go to Advanced Settings > Customizations > Customize the System, expand Entities > Contact > N:N relationships, new.
Select Entity Name of Other Entity to Product. Then select Display Option to Use Plural Name. Save.
Edit the Contact main form and Product main form, insert a sub-grid of this N:N relationship.
To associate contacts and products, just click the Add Existing button in the new sub-grid.
Hello,
General answer - yes, you can create that relationship but this is not what you really need because... one contact can be interested in multiple products and the same time multiple contacts can be interested in the same product so... N:1 relationship doesn't solve your requirement but either native or manual N:N relationship solves that requirement - www.techveze.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
