Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #449

Validation

Show all headers | View raw

Now for my next question ........

I need to enter validation on a serial number field.

I have entered simple validation before.  For example: This field is
required so must be always not empty and if validation fails display
custom error message.

This time ideally I need the field to search another table of serial
numbers.
For example: There's a known faulty batch of goods with serial numbers
in the range 1234-2345
Details of these are stored in a Flagged serial number database

So when a serial number is entered in my table the validation will
say:  Search Flagged Serial Numbers database, serial number field and
if it finds a match my custom error message will appear indicating the
faulty serial number warning.

Is this possible?  If so please advise how best to implement this.

I am using FM Pro Version 11.

Many Thanks

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

Validation JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-24 15:27 -0700
  Re: Validation cortical <cb@corticaldata.com.au> - 2011-10-25 09:15 +1030
    Re: Validation JayBee <Jennifer_Beecroft@hotmail.com> - 2011-12-07 00:37 -0800

csiph-web