C
CJM
In an application I'm working the user has the opportunity to record the
despatching of one or more items with serial numbers.
For each item they despatch, they have to chose the serial no that they want
to despatch from a list of available ones. In many cases, these items will
be of the same time, so the dropdown of available serial no's may be the
same.
So now I need to check that the user hasnt picked the same serial no for two
items....
The serial no fields all have the same name, so when doing the server side
validation I'll be presented with a delimited string as a result. What is
the best way to make sure that none of these serial numbers are duplicated.
I havent thought of a specific solution yet, but I imagine you could use
InStr or Arrays to bully the result out, or perhaps enter the values into a
recordset and manipulate them that way; I havent got as far as figuring out
any kind of sultion yet, but I figured that someone on the NG will have
already thought of a quick & efficient approach - I reckon this must be a
reasonably common issue out there...
Thanks in advance
Cheers
despatching of one or more items with serial numbers.
For each item they despatch, they have to chose the serial no that they want
to despatch from a list of available ones. In many cases, these items will
be of the same time, so the dropdown of available serial no's may be the
same.
So now I need to check that the user hasnt picked the same serial no for two
items....
The serial no fields all have the same name, so when doing the server side
validation I'll be presented with a delimited string as a result. What is
the best way to make sure that none of these serial numbers are duplicated.
I havent thought of a specific solution yet, but I imagine you could use
InStr or Arrays to bully the result out, or perhaps enter the values into a
recordset and manipulate them that way; I havent got as far as figuring out
any kind of sultion yet, but I figured that someone on the NG will have
already thought of a quick & efficient approach - I reckon this must be a
reasonably common issue out there...
Thanks in advance
Cheers