Hi. I know this isn't the right place for this question, but I can't find the right place. So can someone please point me to it.....or just answer the question ...
I have 3 value lists. The first one contains all the values from both of the other lists. When a value is chosen in the first list, I need to search both the other lists and match the value chosen in the first list. Based on which list (2nd or 3rd) I will set a value in another field.
What I'm looking for is something like
if (value1 (match (list1));0
else (value1 (match (list2);1
That's not the right form, but it's something like. What I don't seem to have is a "match"
function.
Can someone help..?/Thanks, Judy