I need to generate an Order # on a form. I currently have a continuous form and the bottom is in Datasheet view. Each record has a check box and the user can check whichever record(s) they want and a SAVE button is provided that saves their selection to a SQL table when the button is pressed. That all works great.
I currently have an Access query that is generating a custom Order # and it runs when that SAVE button is pressed. I'm creating the Order # based off a field in the table and the date/time stamp on when the SAVE button was pressed. I know this is bad practice and it gives me too long of a Order # that my users will need to use in the future to reference.
Its important to note that a Order can consist of multiple records so I don't think adding a autonumber field is going to help. In theory a user can select 100 records before saving and that would make up 1 order.
Any suggestions on how I could do this?
I currently have an Access query that is generating a custom Order # and it runs when that SAVE button is pressed. I'm creating the Order # based off a field in the table and the date/time stamp on when the SAVE button was pressed. I know this is bad practice and it gives me too long of a Order # that my users will need to use in the future to reference.
Its important to note that a Order can consist of multiple records so I don't think adding a autonumber field is going to help. In theory a user can select 100 records before saving and that would make up 1 order.
Any suggestions on how I could do this?