Need input on the best way of going about this.........

Joey Picerno

I have a form where the user can add inventory items. Some items they will have multiple of the same item. I want the user to be able to enter all the information for that item except for the serial number field. I want them to be able to enter ALL of the serial numbers for all of the items at once. EXAMPLE: A dept. buys 10 bullet proof vests. They go to enter the vests into the system. They type in all the information (make, model, cost, description, etc.) when they get to the last one which is serial number they can click the ENTER MULTIPLE button and have a small form pop up with a control to enter all 10 of the serial numbers for all 10 of the bullet proof vests. I just need to know what the best control to use would be and any other information on how to use that control to accomplish what I need. THank you guys for your input. I do appreciate it, as always. -Joey

Christian Graus

How is your database set up ? It sounds like you need a table for item types, and one for individual items ( an item type ID and a serial number, at minimum ).

Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Joey Picerno

Sorry it took me so long to reply. I got wrapped up on something else... What Im really asking here, is what would be the best control to accept multiple serial numbers from the user. Like how you would enter a combo box's items in vb.net in the designer. You click on items in the property window and a rich text box comes up and you enter each combobox item each on a different line. Something like this. I guess I could do it like that, im just asking to see if you or anyone else can think of a better way to do it, and how... My database isnt built yet. I am writing the front-end first and then the back-end(SQL)... Thanks for your help...

Christian Graus

OK, I'd imagine your two options are to have a table to which a serial number is added in each row ( so, a combo box ), or, the way I see it mostly done, is a textbox and the serial numbers are semi colon delimited.

Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert