Forum Discussion

purpletiger's avatar
purpletiger
Frequent Visitor
7 years ago

Problem with Related Row connecting Data with related tables

I am attempting to link data from two child tables of a SalesTransaction Table:

The SalesTransactionLineItems Table contains the SalesTransactionLineItem (PK), Item, Quantity and Subtotal and SalesTransaction (FK)

A SalesTransactionsDetails table contains the EmployeeNumber and SalesTransaction (FK)

 

 

I have tried, to create a column using a measure using Max(EmployeeNumber), new Column using ValueLookup to connect the two tables to no avail. Any recommendations?

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi purpletiger,

     

    Why not connect them with SalesTransaction directly? Can you share a dummy sample, please?

     

     

    Best Regards,