My Customer Database will be split into 4 catagories:
Walkin, Account, Invoice and Quote...
but becasue I'm using the same database for the customers they will all share the same ID counts,
for example, a customer may purchase something and use an invoice (invoice number1) then an account customer arrives, but instead of being account number 1, it will just appear as customer number 2.
I imagined some code in a query like
"Count Invoice" or something, and using it as the invoice number, in an invoice form.
the idea is invoices will have a number so we can refer to them when a customer comes to pay, same as a quote, or an account receipt.
Walkin, Account, Invoice and Quote...
but becasue I'm using the same database for the customers they will all share the same ID counts,
for example, a customer may purchase something and use an invoice (invoice number1) then an account customer arrives, but instead of being account number 1, it will just appear as customer number 2.
I imagined some code in a query like
"Count Invoice" or something, and using it as the invoice number, in an invoice form.
the idea is invoices will have a number so we can refer to them when a customer comes to pay, same as a quote, or an account receipt.
