Hello'

I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.

Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.

I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can be assigned.

While merging customers against an (event category,location), I could see PK  has repeating values as lookup fields have duplicate values, if multiple customers booked for same event,location.

Please suggest how we can avoid duplicate values in lookup fields 

Thanks