zr500racer
Technical User
Hi,
I have created a form that, through the use of an append query, adds product numbers and descriptions to a table. The "item number" format consists of 4 letters followed by 3 numbers. i.e. POEN001 or GOSD003. The form is set up so that the end user chooses the Department (first letter) and Prominent Material (second letter) from a list. They enter a brief description into another set of text boxes, and then hit the button that runs the append query. This inserts the first 4 letters. I need it to add the last three digits on for me. For instance if there is already a POEN001 in the table I need it to take the POEN (Produce, Oak, Euro table, No drawer) from the form and add 002 to the end of it. But I also need it to be able to append 001 to a GOSD if that is input as a first time item. I hope that I explained this well enough. Thanks a million!
I have created a form that, through the use of an append query, adds product numbers and descriptions to a table. The "item number" format consists of 4 letters followed by 3 numbers. i.e. POEN001 or GOSD003. The form is set up so that the end user chooses the Department (first letter) and Prominent Material (second letter) from a list. They enter a brief description into another set of text boxes, and then hit the button that runs the append query. This inserts the first 4 letters. I need it to add the last three digits on for me. For instance if there is already a POEN001 in the table I need it to take the POEN (Produce, Oak, Euro table, No drawer) from the form and add 002 to the end of it. But I also need it to be able to append 001 to a GOSD if that is input as a first time item. I hope that I explained this well enough. Thanks a million!
