Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Customer table issue

Hello,    Trying to determine the best way to set up a customer table in my data model.   I'm having issues with "many to many" which I don't normally get but I've added an element to the data mode...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You could use DISTINCT() to create a one-to-many table. 

According to your sample data, even though you have many-to-many relationships you could also get a unique value with multiple columns.