I have a database where I store all the information about my clients, commissions, invoices, etc and I intend to use it to produce documents such as contracts, invoices etc from the data I have entered.
Right now I've a couple of invoices to produce and as I see it I have two options, create a report or create a form. (I suppose mail-merge could be a third option, but I want to include subreports/forms which list the commissions the invoice covers and I'm not sure if you can do this with a mail-merge, also I would prefer to keep as much as possible in-database).
The invoices are records in a table, Invoices, though the table is based on a query which just selects those invoices which are to be printed using this form/report and brings in other data such as the client's details from that table.
A report seems to offer better layout options, a print-preview etc but each invoice would be a page within a single big report containing all the invoices, which doesn't seem like the most efficient way to do it, finding and selecting individual pages to print out from the report when I get to the point where I have many invoices.
A form would allow me to more easily select which invoice I want to print out, I could use a split form with a list of invoices down the side, but then arranging a layout for printing seems a bit more awkward that way.
Which method would you use in this situation?
Thanks.
Right now I've a couple of invoices to produce and as I see it I have two options, create a report or create a form. (I suppose mail-merge could be a third option, but I want to include subreports/forms which list the commissions the invoice covers and I'm not sure if you can do this with a mail-merge, also I would prefer to keep as much as possible in-database).
The invoices are records in a table, Invoices, though the table is based on a query which just selects those invoices which are to be printed using this form/report and brings in other data such as the client's details from that table.
A report seems to offer better layout options, a print-preview etc but each invoice would be a page within a single big report containing all the invoices, which doesn't seem like the most efficient way to do it, finding and selecting individual pages to print out from the report when I get to the point where I have many invoices.
A form would allow me to more easily select which invoice I want to print out, I could use a split form with a list of invoices down the side, but then arranging a layout for printing seems a bit more awkward that way.
Which method would you use in this situation?
Thanks.