help? saving reports?

[alexi]

Gday guys,

I have a problem with an idea i have.
I create an invoice from a form, which allows me to select the job and task, and then this runs a query wqith this information and spits out the costs needed on my report(with a few calculations on the report).
what i need to be able to do is actually give each invoice a number, be able to save the invoices for future reference, and be able to search on the invoices?
Any ideas how i could achieve this?

Thanks

Alexi

 

[Pat Hartman]

If an invoice and an order are identical, you can use the order number as the invoice number. If they are different, I would create an invoice table based on whatver your business rules for creating an invoice are and just use an autonumber as the invoice number.