Field validation when field is from external FMP data source

[GC GYM]

I have data validation on a field in the main database, however when I edit that field using a separation model, the validation does not seem to work, it allows invalid values.

I can see in the help topic that ODBC data sources do not bring across data validation from the data source. Is this also the case if the data source is FMP? If so, do I just need a script trigger in the separation file to do it's own validation?

[Fitch]

Field validation works with the separation model. Can you give a specific example?

[GC GYM]

It is a date field, validated by calculation, Self ≤ Get(CurrentDate)

Only during data entry, display custom message.

A forward date does not cause a validation error in the separation file. Client machine and FMS have correct sysstem date/time.

 

[GC GYM]

Just tried replacing "self" with <DateField> in the validation calculation but same result