Forum Discussion
Helper VCreating many to many relationship
Super UserBasically you are saying there are seperate customer master table for the exports, and those customer master has different ids for the same customer, correct?
But one thing you mentioned that in your export 1, you have customer id which also exists in Export 2. Having said that, don't you think that customer master for export 2 will work, because that customer master id is in both the export files.
Sorry if I misunderstood your question.
Helper VYes to both...
example
Export 1, customer name EMC Corporation with Sales Logix ID of AZ7TN0002516, customer field included in our CRM software allows us to enter the customer ID from Export 2 of 65182.
Export 2, customer name EMC Corporation, customer ID of 65182
To your point of using export 2 as the master table...If I have a master customer list - this will have only one instance of a customer name/ID. So you are saying using this I can point the customer ID to both export 1 and export 2 and establish the needed connection? Do I understand that correctly?
Emma
- parry2kSorry away from my desk, yes customer master from export 2 will work and both exports will have relation to this master table.