Forum Discussion

Rose__123's avatar
Rose__123
Icon for Helper II rankHelper II
5 years ago
Solved

Many to many relationship - why?

Hi

I don't understand why this becomes a many-to-many relationship? Commission_exeption_table[customer_code] contains no repetitions, but salesInvoices[customer_code] does, I would think it should be a many to one relationship. Both are formatted as text. 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Rose__123 The only way that I could replicate this was to have a blank row in Commission_exception. A blank customer_code. Do you have that?

8 Replies

    • Rose__123's avatar
      Rose__123
      Icon for Helper II rankHelper II
      5 years ago

      Greg_Deckler, I double-checked, but it was fast since my Commission_exeption_table only contains two rows.  Any other ideas?😅 The only thing I can think of is the blank spaces of the Commission_exeption_table since these also appear (and should appear) in the salesInvoices[customer_code], but can that be? 

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Rose__123 It's really difficult to say without the ability to see the data. Since it is only two can you make up two that are equivalent to your two ID's? Is the only difference the number of spaces or ?