I have aable that serves as the many to many link between two other tables. That all works great.
In this table, I have two expressions that each work separately but I need to combine them to get both to work.
In the valid If of one of the reference fields I want to use @Steve tip to prevent duplicate lists from being added. This works by itself.
([_THIS] = [ListID])
I also want the Valid If to include the following. This works by itself.
How can I format an expression that will accomplish both of these? I tried simply combining them with an AND function but didn’t work.
Update: the first expression is working correctly after all. Back to editing it.