1 Reply Latest reply on Nov 11, 2012 6:52 AM by davidanders

    Design Help on New DB

    JohnNeedham

      Title

      Design Help on New DB

      Post

           Greetings:

           I have just purchased a full copy of Filemaker 12 and decided I want to build a "family budget" database application using FM.

           I have some SQL experience and indeed some dbms experience with products like MySQL.

           But I am not sure how to design this concept.  Basically, I am looking to track what bills are due each two weeks and figure out our incomes and available funds after each payday.  I think I will need a "bills" table and an "income" table, but being still fairly inexperienced in db design, I am not real sure.  I am not looking to be as complex as Quicken, more like the envelope system model where you set aside an amount of money in an envelope for each bill/expense.  Naturally, I will want to save Payees with addresses, etc as well.

           Thanks for any suggestions.

           Again, please remember that I am brand new to FM.

           Sincerely,

           Mike Needham