Hi,
I have created a company stock database which is working well but I am looking to expand its functionality to more of a customer orders database with the stock side of things being a feature rather than its primary use.
I have been updating the customer order numbers manually based on order paperwork which I receive from the sales department (the paperwork isn't necessary in order number order). This is working fine at the moment, however, we are looking to change the database so the sales team enter the customer order information and the database autonumbers the order number. I understand the number field can be changed to autonumber using an append query (if there is a better way of doing it then please let me know).
The real purpose of this post is to ask for advice on how to approach our order number structure. If an order is split into multiple deliveries we place a letter after the order number i.e. if the order number is 1000 and is split into 3 deliveries we would have order numbers 1000A, 1000B and 1000C. Of course this won't work with the autonumber in place but I am struggling to come up with a solution to allow the order to be split whilst having an autonumber in place.
Any suggestions will be greatly appreciated.
Thanks,
Chris
I have created a company stock database which is working well but I am looking to expand its functionality to more of a customer orders database with the stock side of things being a feature rather than its primary use.
I have been updating the customer order numbers manually based on order paperwork which I receive from the sales department (the paperwork isn't necessary in order number order). This is working fine at the moment, however, we are looking to change the database so the sales team enter the customer order information and the database autonumbers the order number. I understand the number field can be changed to autonumber using an append query (if there is a better way of doing it then please let me know).
The real purpose of this post is to ask for advice on how to approach our order number structure. If an order is split into multiple deliveries we place a letter after the order number i.e. if the order number is 1000 and is split into 3 deliveries we would have order numbers 1000A, 1000B and 1000C. Of course this won't work with the autonumber in place but I am struggling to come up with a solution to allow the order to be split whilst having an autonumber in place.
Any suggestions will be greatly appreciated.
Thanks,
Chris