Christine,
Typically, using two "not equals" and an "OR" doesn't do what you expect.
If your field contains "XYZ", then the first clause ( != "ABC") is true, and
the whole statement is true. Same goes for when the field is ABC, then the
other side is true. Consider either of the following two qualifications to
get what I think you want, if not, ignore me :-)
---> NOT('fieldname' = "ABC" OR 'fieldname' = "XYZ)
---> ('fieldname' != "ABC" AND 'fieldname' != "XYZ)
Hope that helps,
Thad
On Thu, Oct 28, 2010 at 12:13 PM, Christine <[email protected]>wrote:
> I was maknig a bigger deal out of this than it was. Luckily I only had
> to test that it was not two of the available entries. So the usual
> (('fieldname' != "DEF") or ('fieldname' != "MNO") worked out.
>
> I don't know if this would be appropriate nder a more complicated
> scenario.
>
> Thanks all just for being available....
> Christine
>
> On Oct 28, 11:42 am, Christine <[email protected]> wrote:
> > I have a field on one form that utilizes a search type menu (which
> > references a field on another form). I need to create an ACTL for the
> > first form where the Run If statement says ‘If field value is ABC or
> > XYZ” where ABC or XYZ is a field value on the second form.
> >
> > The Search-type menu has more options than ABC or XYZ.
> >
> > Does anyone have an example of how I can validate the chosen field
> > value on the first form against the multiple field value entries on
> > the second form?
> >
> > ARS 7.1.00 Patch 002
> > Incident 7.0.03 Patch 007
> >
> > Thanks,
> > Christine
> >
> >
> _______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
