The business would like the ability to add multiple 'Market Segments' to a Company. I want to achieve this by placing a Sub-Grid on the Company form. I created the 'Market Segments' entity, with 21 Market Segment values, created a 1:N relationship from Company:Market Segment, and added the Market Segment Sub –Grid on the Company Form.
When testing to add multiple Segments to the Sub-Grid for a Company this works fine, but when I try to add the same Market Segment value ‘Aerospace’ to another Company, I get the above error: 'Error: The record is already associated with another record'.
What am I missing here? I should be able to add the same Market Segments to different Companies. I know I am missing something simple.
Thanks.
*This post is locked for comments