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

On 25/10/11 8:57 AM, JayBee wrote:

Add a conditional format to the layout with default text the same
colour as the background, and a calculated CF to make the text white on
a red fill ( for example) i.e. big red flag - evaluating the related
flagged table

Same construct can be used to flag insert image/file as reference into
a container field; i.e. give visual feedback when insert a ref is
required ( or the opposite)

Thanks for this Cortical I developed a solution using conditional
formating and validation.
Many Thanks