Other (neater IMHO) ways to write the formula are:
---
if P1F6 = "Y" or P1F6 = "N" then P1F6 else "" endif
---
OR
---
P1F6 cases
case cv = "Y" of cv endof
case cv = "N" of cv endof
default ""
endcases
---
I'd probably go with the short and sweet first one, although I admit to
a fondness for the cases-endcases construct. Both just seem easier to
decipher later, rather than nested if-then-else statements. Same exact
result though, and your advice is dead-on. :)
Tim Rude
On 12/22/2016 8:00 AM, [email protected] wrote:
Hi Dave:
You would use a formula on your field like the following (assumes your
U1 field is P1F6):
if P1F6 = "Y" then "Y"
else if P1F6 = "N" then "N"
else ""
endif endif
Set validation to "Automatically computed at any change and when
record is saved".
This won't allow any entry except Y or N to be saved.
Incidentally, be sure to find and download Ralph Alvy's book
"Mastering DataPerfect" if you haven't already done so. It's a great
guide to fully using DP.
Paul Durban
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
