[MS_AccessPros] Auto Invoice Number

 

I am putting together a database to track sales for a new company.

 

I have a table called.

 

t_Invoices

 

with the typical fields

 

IncIncID – Auto number

IncNumber – Invoice number

IncOrgID – FK to the purchasing organization

 

Etc.

 

I am trying to figure out how to make the Invoice number (IncNumber) automatic, no duplicates.

I tried to make it an auto number but I now know that I can have only one auto number per table and the Key field already has that.

 

Somehow I have to add 1 to the previous value in the IncNumber each time a new one is created.

 

I am betting I put a default value in the invoice form that I build the invoice in.  What I can’t figure out is how to get the form field to look back one record for the most recent number.

 

Any help would be greatly appreciated.

 

Thank you,

Bill

Minnesota.

Access 2013 

__._,_.___

---

Posted by: "Bill Singer" <Bill.Singer@at-group.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___