help? saving reports?

alexi

Registered User.
Local time
Tomorrow, 02:46
Joined
Feb 26, 2003
Messages
65
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom