on 11-01-2007 1:58 PM
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.
Please try with HAS ANY VALUES. It worked for us.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I managed to find a way to do this using HAS ANY VALUES.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.