Validating Data Entered

[Guest]

What is the best way to validate data entered - I have a field called box
number that represents an box of inventory. This box may have several items
returned in it. I want the data entry clerk to be able to enter the box
number and then the items that are in the box. But I want the box number
he/she enters to be valildated by the numbers that are assigned in previous
query - to avoid incorrect entry of box numbers (there would be thousands of
box numbers) with a possiblity of dozens of items in each. So if I assign
box 789849 to a location number 2501 I want the clerk to be able to select or
enter 789849 and enter the items, but if she were to enter 690949 and it is
not on the list, I want an error. I tried a combo box but it doesn't allow
you to search for a box number.

Thanks Lynette

 

[Stefan B Rusynko]

You would need a database to store the box & location information
- then check the form entry data against the database w/ custom server side code

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| What is the best way to validate data entered - I have a field called box
| number that represents an box of inventory. This box may have several items
| returned in it. I want the data entry clerk to be able to enter the box
| number and then the items that are in the box. But I want the box number
| he/she enters to be valildated by the numbers that are assigned in previous
| query - to avoid incorrect entry of box numbers (there would be thousands of
| box numbers) with a possiblity of dozens of items in each. So if I assign
| box 789849 to a location number 2501 I want the clerk to be able to select or
| enter 789849 and enter the items, but if she were to enter 690949 and it is
| not on the list, I want an error. I tried a combo box but it doesn't allow
| you to search for a box number.
|
| Thanks Lynette
| --
| Lynette

 

[Guest]

So I need two data bases - one with the structure info (box #s, locations,
products etc) then another only for data entry?

how to I compare the two?

 

[Thomas A. Rowe]

Why not just add a field to the database with the structure for input?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

So I need two data bases - one with the structure info (box #s, locations,
products etc) then another only for data entry?

how to I compare the two?
--
Lynette

You would need a database to store the box & location information
- then check the form entry data against the database w/ custom server side code

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| What is the best way to validate data entered - I have a field called box
| number that represents an box of inventory. This box may have several items
| returned in it. I want the data entry clerk to be able to enter the box
| number and then the items that are in the box. But I want the box number
| he/she enters to be valildated by the numbers that are assigned in previous
| query - to avoid incorrect entry of box numbers (there would be thousands of
| box numbers) with a possiblity of dozens of items in each. So if I assign
| box 789849 to a location number 2501 I want the clerk to be able to select or
| enter 789849 and enter the items, but if she were to enter 690949 and it is
| not on the list, I want an error. I tried a combo box but it doesn't allow
| you to search for a box number.
|
| Thanks Lynette
| --
| Lynette