G
GregoryJ
I'm developing a web page that is to replace an existing older Unix
Application. In the other application the user is able to type in text, or an
abbreviation into a TextBox that is related to a lookup table. For example, I
have a field named "Color" where the user can type in WHI to indicate White.
The value WHI exists in a tblColor table. Most data-entry personnel know that
White's code is WHI, so there is not need for the field to be a combobox.
What would be the best way to allow someone the ability to type in a value
of WHI into a color field and compare it against the value in the tblColor
table? The value entered must exist in the table and I don't want to be
making a round trip to the server everytime.
My thought is if I had an array of some sort I could do something. But, I'm
not so sure how I would approach this situation in a Web Page.
Can anyone give me an idea of how to approach this?
Thanks, Greg
Application. In the other application the user is able to type in text, or an
abbreviation into a TextBox that is related to a lookup table. For example, I
have a field named "Color" where the user can type in WHI to indicate White.
The value WHI exists in a tblColor table. Most data-entry personnel know that
White's code is WHI, so there is not need for the field to be a combobox.
What would be the best way to allow someone the ability to type in a value
of WHI into a color field and compare it against the value in the tblColor
table? The value entered must exist in the table and I don't want to be
making a round trip to the server everytime.
My thought is if I had an array of some sort I could do something. But, I'm
not so sure how I would approach this situation in a Web Page.
Can anyone give me an idea of how to approach this?
Thanks, Greg