Invoice Number

[Guest]

I want to create a unique invoice number in a table
the problems is that i store orders and returns in the same table

so i was wanting to add a record to an invoice table from a form
then do a dlookup on the resulting record with an auto number field
only on records that require an invoice number. I know what i want to do but
not
how to do it or if it is the right way to go about it

 

[Joseph Meehan]

I want to create a unique invoice number in a table
the problems is that i store orders and returns in the same table

so i was wanting to add a record to an invoice table from a form
then do a dlookup on the resulting record with an auto number field
only on records that require an invoice number. I know what i want to
do but not
how to do it or if it is the right way to go about it

I'm sorry but I am a little confused about what you want. I will make a
few observations that may help.

First, auto numbers are designed to provide unique numbers. Generally
using them anywhere that a user may see them can cause confusion for the
user as they don't always follow an order. They may run 5, 6, 7, 3, 122,
8,... Etc.

Depending on a number of factors, you may want to have separate tables
for orders and returns or you may want them in the same table. What other
information will you have? What calculations will be needed?