I am trying to build a rolling forecast input form, which should display the past quarter of actuals + 4 future quarters (the current one + 3 future quarters.
How should I:
1) structure the forecasting table?
2) structure the actuals table
2) create the query to display a rolling view of 5 quarters?
3) build the form to display the past quarter data and allow entries for the current quarter + the following 3?