Adding Months to Budget

[jpac]

Hi Guys, I've attached a mock-up of a database I'm setting-up. What I'd like to do is have each new record I add post the next month & year using a script. I want the month and year to show in the header. Can someone help. Newbe ,Joe

[-Queue-]

You can do this using an auto-enter calculation and a Cartesian self-join relationship sorted by the date descending.

I've added DateMonthYear field, which is a date field formatted on the layout to display the month name and year. If there are no records present, it auto-enters the first day of the current month. If there are previous records, it auto-enters the largest date plus one month.

See attached for changes.

PacittiHousehold.zip