Hi
MS-2003-I have created a simple customer, order database (4 tables in total) and populated it with 5000 records. The tblorder uses ordernumber as PK which is a text field with data in the form of COD000, COD001. I have now been asked to create an order form where the ordernumber automatically populates to the next sequential value. I am new to access with very little knowledge of code. I have used a query to increase a long integer field by 1 using max, but this doesn't work with text fields. So what would I put in the unbound ordernumber field in the form to do this and how would I make it automatic. Please help.
Many Thanks
MS-2003-I have created a simple customer, order database (4 tables in total) and populated it with 5000 records. The tblorder uses ordernumber as PK which is a text field with data in the form of COD000, COD001. I have now been asked to create an order form where the ordernumber automatically populates to the next sequential value. I am new to access with very little knowledge of code. I have used a query to increase a long integer field by 1 using max, but this doesn't work with text fields. So what would I put in the unbound ordernumber field in the form to do this and how would I make it automatic. Please help.
Many Thanks
Last edited: