Jump to content

Field validation when field is from external FMP data source


 Share

This topic is 2315 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

This topic is 2315 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.