K
Kirk P.
I've created a simple billing database. What I've got thus far is a Customer
Form for the user to review - once they are satisified they click a command
button Create Invoices, which allows them to enter the desired invoice date.
At this point, I know the entire population of CustID's to invoice, and the
invoice date desired. I just need to assign the unique, incremental invoice
numbers within that selected invoice date. I'm hoping to create a table like
this...
CustID InvDate InvNbr
1 4/1/2007 M700001
2 4/1/2007 M700002
3 4/1/2007 M700003
Any ideas how to proceed?
Form for the user to review - once they are satisified they click a command
button Create Invoices, which allows them to enter the desired invoice date.
At this point, I know the entire population of CustID's to invoice, and the
invoice date desired. I just need to assign the unique, incremental invoice
numbers within that selected invoice date. I'm hoping to create a table like
this...
CustID InvDate InvNbr
1 4/1/2007 M700001
2 4/1/2007 M700002
3 4/1/2007 M700003
Any ideas how to proceed?