Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #450

Re: Validation

Show all headers | View raw

On 25/10/11 8:57 AM, JayBee wrote:
> 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


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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | 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