Forum Discussion

mgost's avatar
mgost
Frequent Visitor
1 year ago

Multiple relationships between 2 tables

Hi everyone,   I really need your help. I am stuck. I need to calculate Amount by User in Document Number, but user can occur in any of three columns - First User, Second User or Third user. I can...
Need Help
ajohnso2's avatar
ajohnso2
Solution Supplier
1 year ago

Can you provide some sample data from your three tables that will show this issue you have?

  • mgost's avatar
    mgost
    Frequent Visitor
    1 year ago

    Sorry I can't share company data, and don't have so much time to recreate everything with dummy data.
    but here is detailed diagramm: