Howdy folks, It seems like this ought to be a simple thing, but I'm just not quite getting there. I need to have a few fields that accept either "Y" or "N". U1 fields are the obvious choice. How can I constrain the user's input to only "Y" or "N"? Setting range validation on the field obviously won't do it, since you can't give a list of discontinuous values to validate against.
I tried adding a calculated field next to it that translates the "Y" and "N" to 1 and 0, and defaults to 2 for anything else, then putting 0-1 range validation on that. It sort of works if that surrogate field isn't hidden, but if it's hidden, the validation doesn't seem to run. Is the simplest way to do this by creating a panel that holds the "Y" and "N" values, and using that as a target for no-create data links in the entry forms? I could swear I read something in passing about doing this kind of validation with field formulas and range validation, but I'm not having any success finding it now. -Dave Britten _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
