QDESIGN LOOKUP question

[jlkeepers@mmm.com]

Fellow PowerHouse users,

I am in uncharted territory and was wondering if anyone could point me in the
right direction.  What I am trying to do is validate a value entered by an end
user.  The kicker is that the user is entering 6 digits and the validating value
is 9 digits with either leading "000" or "001".  Is it possible to setup a field
lookup to do the following:

     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.

Sincerely,
Jeff Keepers


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.