J
JD
We have two systems in place for "temporary" invoices.
One is a work order or work performed that needs to be
invoiced and the other is a sales order that specifies
products we sold that need to be invoiced.
Right now, there is a separate table and form for
invoices that just copies the information from one of the
above tables to the invoice table.
I was thinking of having a "invoice" button on each work
order and sales order form to click and then it would
generate a new InvoiceID in the invoice table with a
relationship to the WorkOrderID or SalesOrderID.
How can I get the Invoice number to keep count when doing
this or can this be accomplished?
Thanks
JD
One is a work order or work performed that needs to be
invoiced and the other is a sales order that specifies
products we sold that need to be invoiced.
Right now, there is a separate table and form for
invoices that just copies the information from one of the
above tables to the invoice table.
I was thinking of having a "invoice" button on each work
order and sales order form to click and then it would
generate a new InvoiceID in the invoice table with a
relationship to the WorkOrderID or SalesOrderID.
How can I get the Invoice number to keep count when doing
this or can this be accomplished?
Thanks
JD