Forum Discussion

sully343's avatar
sully343
Frequent Visitor
3 years ago

Information from Seperate Table

for my visualization, I have a table that shows sales. This uses information from 2 tables:     Payments: (which contains information on the actual sale such as amount, tip, credit card informatio...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Just put a sample of your 2 tables please it will be easier to help you

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Did you link the id on each table ?

    • sully343's avatar
      sully343
      Frequent Visitor
      3 years ago

      I believe I did...I tried a many to many relationship and a one to many and neither have worked..

  • sully343's avatar
    sully343
    Frequent Visitor
    3 years ago

    PAYMENTS Table:

     

    IDAmmount           Tip 
    brrED0RUSJ6lazIQgmMZlFGpvB942047703VISADEBITsq-1-hMwpq-fCXsS2epaU5XB-FMQK-yn2LnwhJgnjQkz4x_NkvQrWn6FZUNQtq8sltIrCaptured brE nullCARDCompleted141310/1/2022 8:49:20 PM

     

    CUSTOMERS Table:

     

    IDF Name

    L Name

    		 Email   
    brrED0RUSJ6lazIQgmMZlFGpvBAnthonyDoe [email protected]FALSE 1/2/2022 7:01:12 PM