Forum Discussion

szub's avatar
szub
Helper III
6 years ago

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi szub 

Modified "SERIAL_NBR" column of your "TransactionData" table as below

Create relationships

srial 1 has 1 row record in "Claim" table, serial 1 has 2 rows in "Transaction" table, so wen adding columns from two tables in to a visual, it shows all data from two tables like crossing join.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

szub's avatar
szub
Helper III
6 years ago

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