This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have had a time with enum list trying to figure out what I’m doing wrong. So table 1 has an enumlist with a validif of Select from a table2[column1] where the contactid in table 2= the current row contactid. This brings back the right list in the dropdown and stores the data correctly in the table. But it results in an invalid entry error still. Awhile back the data used to be stored in the enumlist field as table2::column1value but now it just stores column1value. My thoughts are that when it stores the multiple values of the enumlist and then checks against the valid if statement after it is stores, it doesn’t fit the select statement anymore. Should I be using something other than a select statement in the valid if? Is there something I’m missing. This feel very basic but I’m just scratching my head trying to figure out what i’m doing wrong.
sorry…I little more…Criteria for certain rows in Table2 is another column…ContactID, (which, if it matters, is a ref column in both Table1 and Table2 to a Table 3 (contact table)
Please provide screenshots of all expressions involved, such as the Valid_If expressions. Please also provide screenshots of the column configuration screens for the involved columns.
Yeah…unfortunately I tried that. This is totally eating my lunch. What do you think if I break that “other” field out into it’s own table? It shouldn’t matter because it will probably have a similar valid if statement, but that’s the only thing I can think of to help.
LinkedIn
Twitter
