AnsweredAssumed Answered

Monthly savings database

Question asked by RyanAshton on Jun 19, 2018

Hi all,


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.