Forum Discussion

Oros's avatar
Oros
Post Prodigy
2 years ago
Solved

Relate tables

Hello,   I have 3 tables (DOLLAR and QTY tables are related with the third table PRODUCT).   The DOLLAR and QTY columns are correct, but as soon as I bring in the CUSTOMER column the QTY for each...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Create a single column table of all unique customers.  Create a Many to One relationship from the Qty and Dollar Table to the Customer Table.  To your visual, drag Customer from the Customer Table.

    Hope this helps.

aj1973's avatar
aj1973
Community Champion
2 years ago

Oros New Update:

 

Use CUSTOMER from the DOLLAR Table instead

 

 

And Use Product from the Dollar Table

 

Oros's avatar
Oros
Post Prodigy
2 years ago

Hello aj1973 ,

 

Unfortunately, the result is still incorrect.  The QTY column still shows duplicate values.  How do we avoid the duplicate values and show the correct values instead?  Thanks.

 

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

     

    • Oros's avatar
      Oros
      Post Prodigy
      2 years ago

      Hi aj1973 ,

       

      Thanks again for your reply. 

       

      Unfortunately, the duplicate (incorrect) values still show up in the QTY column.