Skip to Content
avatar image
Former Member

Is it possible to use conditional If/Then statements w/Multi-Valued fields?

As the title indicates, is it possible to use conditional If/Then statements with Multi-Valued fields? Basically what I have is a lookup table that has a multi-valued field in it. I want to run a validation on the main table that checks to see if a certain field in the main table is included in the array of values in the multi-valued field in the lookup table. Is this possible? Just doing a standard "If field=multiValuedField" does not seem to work.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 01, 2007 at 02:20 PM

    I managed to find a way to do this using HAS ANY VALUES.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2007 at 03:54 PM

    Please try with HAS ANY VALUES. It worked for us.

    Add comment
    10|10000 characters needed characters exceeded