AnsweredAssumed Answered

weird validation... or could it be me?

Question asked by synergy46 on Feb 21, 2009
Latest reply on Feb 21, 2009 by synergy46

Title

weird validation... or could it be me?

Post

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:

 

Thanks

 

Outcomes