Create Report from 2 Tablets Parent to Child
I need help creating a report from 2 related tables. Budget and Budget Amendments. The report i need would be a basic bar graph that will show Budgets Executed and Budget Amendments Executed over t...
Forum Discussion
Conceptually I'm not seeing how this can work. Even if you do the chart off the child table using a chart type "Line and Bar" which can do two different fields to plot. then you still have the problem as to the X axis dates.
If the chart is off the child table then you can use the child dates on the X axis, But then even if you were to plot a lookup of the Parent Budget values (and use averages so as not to double / triple count), I'm not seeing a way to use a different date value for the Parent's value.
If the chart is off the child table then you can use the child dates on the X axis, But then even if you were to plot a lookup of the Parent Budget values (and use averages so as not to double / triple count), I'm not seeing a way to use a different date value for the Parent's value.