P
Petterq
Hi.
I am develoing an invoicing system. I have created the tables that hold all
the data required for the invoices. I have a separate table that hold the
actual invoice data with invoice #, date, etc.
When running the report that creates new invoices, I would like to
automatically number the invoices, and update the table that hold the invoice
data.
The program should find the last (higest) invoice number already registred,
and start numbering the new invoices with the first free number. Then the
invoice number, client number, date, and content of the invoice should be
written back to the table holding the invoice data. Except for the invoice
number all the other data is created/collected with a query into the report
creating the invoice.
Can anybody give me an description on how to do this?
Regards Petterq
I am develoing an invoicing system. I have created the tables that hold all
the data required for the invoices. I have a separate table that hold the
actual invoice data with invoice #, date, etc.
When running the report that creates new invoices, I would like to
automatically number the invoices, and update the table that hold the invoice
data.
The program should find the last (higest) invoice number already registred,
and start numbering the new invoices with the first free number. Then the
invoice number, client number, date, and content of the invoice should be
written back to the table holding the invoice data. Except for the invoice
number all the other data is created/collected with a query into the report
creating the invoice.
Can anybody give me an description on how to do this?
Regards Petterq