Forum Discussion
Helper VCreating many to many relationship
Helper VI can obtain a customer master table - but each export is coming from two different systems....so the the ID for customer ABC will actually have a differnet ID from each table? How would I make that work with two differnet customer master tables?
Emma
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.
- emma313823
Yes 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.