Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012

    Unanswered: How do I automate the creation of a report?

    I am trying to have a database which will create invoices.

    I have made all of the actual database data now and am working on outputs.
    I am new to databases so don't understand much.

    How can I automate the creation of the reports I have in the attached DB?
    The one I created I entered the booking_ID into the query the reports are based on, how can I do this for every booking automatically (even when new ones are added)?

    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    consider placing a flag on the invoice main record that identifies the invoice is to be printed
    run your invoicing report pulling those invoices requiring printing
    at the end of the report reset the flag. the one problem with this design is that there is a risk that someone may request an invoice after the report has startede but Before its completed. you can get round that by, say, running the invoice print when you know there is no one else in the DB
    you could lock the table so updates and additions cannot be permitted.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2012
    I'm sorry, I don't know how to do any of that

    I'm very new to databases. Will that automatically create invoices (reports) for each new booking entered?

    This isn't actually going to be used in real life by a business or anybody else so I am not particularly worried about small bugs etc... I just need to it work to be honest.

Posting Permissions

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