I have created a database for monitoring my monthly savings. It has 3 records (for the last 3 months) and each record has line items of what I'm putting my money towards (see attached).
How do I:
1) Create a script which will create a new record along with all line items from the previous record.
2) Be able to fill in a new income amount for the new record.
3) Automatically fill in the amounts for each line item on the new record based on the income amount.
Thanks for your help.