You'll need a number of additional tables.
A Transactions table that you can set up just like a check book register to record your spending (checks, debit transactions and withdrawals) and income ( Deposits ). Most likely, you will need to link this to another "line items" table so that you can take a single transaction such as using a debit card to buy a bunch of different things from a store and itemize parts of it against your budget items. Your budget table can list each budget category you and any other members of your household that help you spend this money agree upon. (The best DB in the world will fail unless you work that part out. ) Your savings goals can be records in this budget table.
That gives you tables and relationships like this:
Transactions---<BudgetItems>------Budget (---< means one to many)
There are a number of details to be worked out and more than one approach in many of these areas are possible depending on your skill set and what you want to do. Your budget table, for example can be a set of records tagged by each month or quarter. That way, you can see actual spending in each budget category and compare that to the specified budget amounts for that time period. A script can use the previous month or quarter to duplicate these records to produce a set for the next time period where you can then make any need adjustments based on how well the previous budget worked...
Thanks for the reply. Can you tell me specifically which script might be helpful with this case?
Is there a URL I can use to see what the functions of the different scrpts are? Do you know if there is a FMP Users Group in the Portland Ore. area?
Well, I haven't described a single script in my original post here. You first have to set up a table structure that works before you take a look at any scripting.
Don't know what user groups may be close to you. You'd need to web search that one out for yourself.