Forum Discussion
Table Relationship Issues
Hello, I have a sales by serial number and claims by serial number table and the only common field is the serial number. Both tables can have the serial number listed more than once for various ...
Hi v-juanli-msft ,
Thank you for your response. I realized that I did not have a serial number listed more than once in my sample Sales Transaction data once I had left for the day and have now corrected. Thank you for realizing that.
All the training and dicussions I have had with others have advised to stay away using many to many relationships, which is why I did not use it. Are there any negatives that you have experienced with using Many to Many?
Thank you
could you also make a mockup in excel of how you want your table/output to look like?