If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Then I make a report based on the above table and issue that as the invoice to the costumer, who is jack here.
How can I make a unique invoice number, which automatically increases sequentially for each invoice? Do I need to add a new column to the table? I also need to be able to look for a specific invoice based on the number, or date.
Thank you

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

if your invoices numbers just need to be unique the use the autonumber datatype. but that doesnt' work if you must have no missing numbers (something accountants/auditors can get very upset about). Also if you are a small trader then havign a numbering system which runs from 1 sequentialy gives your competitors a clear indication of how much or how littel trade you are doing.

if autonumber doesn't cut if for you then create an function which supplies the next available number. there's plenty of examples on this site and on t'web

if you need to obfuscate the onvoice number (and there's lots of ways to do that, then you will need to extend that function to apply whatever obfuscation you want to apply.

prefixing with year and suffixing with month and day is a good'un, or interleaving minth and day as a suffix also works

eg
27 dec 2014
invoice number 3405, lets assume a 6 digit number that is obfuscated

others things:- add a checkdigit
or think of some equally obtuse way of masking the true invoice number. but make certain your sequential number is clear so that users of the system can quickly identify the correct invocie without the onfuscation

if your invoices numbers just need to be unique the use the autonumber datatype. but that doesnt' work if you must have no missing numbers (something accountants/auditors can get very upset about). Also if you are a small trader then havign a numbering system which runs from 1 sequentialy gives your competitors a clear indication of how much or how littel trade you are doing.

if autonumber doesn't cut if for you then create an function which supplies the next available number. there's plenty of examples on this site and on t'web

if you need to obfuscate the onvoice number (and there's lots of ways to do that, then you will need to extend that function to apply whatever obfuscation you want to apply.

prefixing with year and suffixing with month and day is a good'un, or interleaving minth and day as a suffix also works

eg
27 dec 2014
invoice number 3405, lets assume a 6 digit number that is obfuscated

others things:- add a checkdigit
or think of some equally obtuse way of masking the true invoice number. but make certain your sequential number is clear so that users of the system can quickly identify the correct invocie without the onfuscation

thank you very much,
lets suppose i have made a type of auto-number. Now,can you instruct me if how i can assign a number to a series of orders shown in an invoice?
I mean, in the above example, there should be a number, 13896 for example, assigned to orderID from 12 to 17. If another costumer makes orders with orderID from 18 to 21, the invoice number 13897 will be assigned. i will need in the future to find the orders asigned to any invoice number, for example orderIF from 12 to 17 for invoice number 13896. my question is that how can i find orders assigned to an invoice number.

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

Wrong way round. Assign orders to an invoice, using an intersection table that identifies what orders comprise this invoice. Logically its the same approach as when creating an order.
an order exists, it has one or more details of items ordered. Those items ordered are an intersection table identifying the order number ( and through that the address, customer name and so on) and the product table.

how to make such a invoice number?

I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". Can we assign a unique number, named invoicenumber here, for each set of orders hat a costumer puts? Please see this table: