weird validation... or could it be me?
I have a single table...
There are cityV and stateV fields for Visitors
There are cityC and stateC fields for Company
In Auto-Enter for CityC I calculated CityC=CityV
This way whatever city is in the CityV field shows in the CityC field. This works well.
However, sometimes the CityC is NOT the same as the CityV and the user needs to overwrite the CityC Field. However, it needs to be overwritten as CITYC=PROPER(CITYC). If I put this in the "Validation by Calculation" when I commit the record I get:
"CityC is defined to contain only specific values." REVERT YES NO
It seems like the validation by calculation is looking to perform a boolean function and therefore return a boolean value. If this is true, is there a work around to do a PROPER(CITYC) evaluation in validation? If not, why not?:smileysurprised: