I only want to show an Action if a criteria is met from another table.
The two tables are:
“qryAppsheetData” contains [JobID]
“WorkshopComplete” contains [JobID] and [Complete]
qryAppsheetData should only show an Action for the row if [JobID] matches both tables and Column [Complete] = “N”
I hate expression syntax, can anyone provide a quick solution?
Acheived by adding a virtual column and creating a ref to the 2nd table. Then a Valid_If of:
It doe sthe trick.