QDESIGN LOOKUP question

[Chris Sharman]

>     If "000" + field entry = validating value
>                    valid
>                else if "001" + field entry = validating value
>                          valid
>                         else notify end user entry not valid
>                end if
>
>I attempted this using two lookups with the first one being optional but that
>doesn't work since both lookups have to be correct.  An optional on both lookups
>would make the point of lookup useless.  Any assistance on this matter would be
>greatly appreciated.

You need some procedural code ...

Drop the lookups from the field statement, and do them explicitly in an edit
procedure.
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.