QDESIGN LOOKUP question

[Pickering, John (NORBORD)]

Jeff

I don't think you'll find a sensible way to do this with field statement
options such as lookup. But it most certainly can be done with code very
much like what you supplied in the EDIT procedure.

Regards,
JWP

> -----Original Message-----
> From:	jlkeepers@mmm.com [SMTP:jlkeepers@mmm.com]
> Sent:	Wednesday, January 17, 2001 10:34 AM
> To:	powerh-l@sphere.swau.edu
> Subject:	QDESIGN LOOKUP question
> 
> 
> 
> 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.