Whats the best way of doing this?

[JustMe]

If I want to create a table for Invoices, what is the best way of
incrementing the Invoice number from an arbitrary start point.
Would it be:
1. Use an Autonumber field?
or
2. Create a Number field and set to Autoincrement in code.

If it's the 2nd listed ,
Can or Would someone Please tell me the code I would use and where to place
it in design scheme of things?

Thanks

 

[Guest]

What I have done in this instance is use a combination of
fields. (i.e. autonumber + date, or something like that)
This is what worked for me - I had 3 data fields. 1 would
be autonumber the other would fill in the date (both of
these fields would not be visible) then in another field
that was visible - I would combine the 2 of them - it is a
good way to know when the data was entered, etc. Hope
this helps.

Matt

 

[TC]

You do understand that invoices will need >several< tables?

For example:
tblCustomer - one row for each invoicing customer;
tblInvoiceHeader - one row for each invoice;
tblInvoiceLine - one row for each invoice line;
tblProduct - one row for each invoicable product or item;
maybe a price history table, etc.

HTH,
TC

 

[Tim Ferguson]

If I want to create a table for Invoices, what is the best way of
incrementing the Invoice number from an arbitrary start point.
Would it be:
1. Use an Autonumber field?

An autonumber is convenient BUT will have gaps in the sequence. Some
auditors find it worrying to see missing invoice numbers, so in that case
an AN would not be suitable. Depends on your business needs.

If it's the 2nd listed ,
Can or Would someone Please tell me the code I would use and where to
place it in design scheme of things?

Google for "Access custom autonumber", or look in Dev's site
<http://www.mvps.org/access> or Steve Leban's <http://www.lebans.com>
There are lots of different solutions, depending on your exact needs.

Best wishes


Tim F