I have a Table with a Column that contains a reference.
I put a valid if statement to filter that allow a select list of reference values from the "Names Table
When I add an entry it works and I can only select from those three names.
However, I added an action on another table where the same reference is telling it to Place the Name ID into the proper column
and it works
If it is suppose to put Jim in the row when you look at the Raw table is has the value “13”
and the View displays “Jim”
But The Entry also says “The entry is invalid”
If Click the drop down to assign different name it gives me these option
Listing Jim twice (I guess the Correct Jim and my Jim)
I can remove the error by just removing the Valid if statement, But I still want that. If I add the entry without the action I still only want to get three options
And it is not just Jim. My action actually creates three new rows with these names in them and all three do the same thing.
Any Ideas on What I may be doing wrong here?