How to prevent duplicate values in column and allow only a certain range ?

Hi Pros !

Got a forms4.5 App, that allows entry of numbers into a table. One column of this table has let's say row number values that are allowed 1-10.

How do I force my users, or notify them that when they try to enter a value (a number) in this particular column, that a row with this number in that particular column already exist, and therefore are not allowed to use this number). And how do I define a possible range of numbers that is allowed for entry ?

So if the column has already rows numbers with 1,2,3,4,5,6,7,9,10,,, the only value allowed should be 8, if anything else is input I need to message the user. Have no trouble on the message part, but how do I check for duplicate entires, at comit time.

I like the "format mask" "MM-DD-YY" type validation, where I tell the user what the format is , so he can retype it . Is this possible for checking on duplicates, and if they are excist to flag the user ?

Thanks for all your help and suggestions.

Jens
jens_at_deutschware.com Received on Tue May 27 1997 - 00:00:00 CDT