RE: Can a relationship between Contacts and Products be created?
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.
