Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013

    Unanswered: Do I need another table for Receipts?

    Ok my question is one that may get an a response like this.. "Just make the table lazy sod!"

    I am reworking a a database for Invoicing. I have created several tables for Contacts and the Invoices, and Payments. I have also created auxiliary tables, linking the main tables with primary/foreign keys where many-to-many relationships exist. I understand that this is good practice in following the rules of normalisation and I am really happy with how well this makes thing work.

    I am doing this using Filemaker by the way.

    One of the last things to do is to issue a receipt to the Customer/Contact when they make a payment. Looking at the data available in the Payments table. Data regarding the Customer and Invoice is also available. One or Several payments can be made, each with it's own record to represent paying either the invoice in full or in instalments. I have this set up so that one can view a list of payments through a portal in a variant view of the invoice.

    I am thinking that I can get away with just making a layout from the Payments table that will do as a receipt. There is just something niggling though at the back of my mind that says this is the wrong approach.

    Can anyone give me a good reason why I need to build a table for the Receipts.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The answer to this kind of question always seems to be "it depends".

    If Receipts and Payments are the same thing, then only one table is needed. To me, Receipts are given to show what/when/where someone gave a remittance (in this case probably cash or the equivalent). Payments are made from the remittance toward one of several uses, to a specific invoice, toward a retainer or fee, "on account", etc. One remittance (Receipt) can be used for one or many payments.

    You need to define (at least within your own head) what these things are or represent. Once you do that, deciding how many of what you need ought to be easy.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2013
    Cheers Pat

    That sorts it in my mind. I my instance the same table will do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts