T
Ted
I have a customer who basically does the same work week after week and wants
to use the same original Invoice/Work order until he changes it. To handle
this I added a random number to be the Invoice number instead of the OrderID
so that whenever the report ran the invoices, it would have a different
number. Client would like to have it follow a sequential numbering scheme.
How would you suggest handling this? Should I have another table holding
sequential numbers along with a yes/no box that could be monitered and
updated by Visual Basic? Any suggestions would be appreciated.
Thanks
to use the same original Invoice/Work order until he changes it. To handle
this I added a random number to be the Invoice number instead of the OrderID
so that whenever the report ran the invoices, it would have a different
number. Client would like to have it follow a sequential numbering scheme.
How would you suggest handling this? Should I have another table holding
sequential numbers along with a yes/no box that could be monitered and
updated by Visual Basic? Any suggestions would be appreciated.
Thanks