Forum Discussion

ChrisDurham's avatar
ChrisDurham
Frequent Visitor
5 years ago
Solved

Relationships

Good Morning, I am trying to generate a budget vs actual report but can;t figure out how to set the relationships to work. I have the following structure :-

I have a customer table with customer details in, a budget table with a budget date, amount and customerID and an invoice table with invoice date, amount and customerID. What I want to be able to do is create a table with customer name on the left, months and years across the top and then the sum of invoices and the sum of budget amounts for each customer and each period. Clearly I need to link the customerID to both the budget and invoice table, but then I also need to make sure that I display only budgets and invoices from the same time period. What is the best way to achieve this ?

 

2 Replies