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?
Cheers
Acheived by adding a virtual column and creating a ref to the 2nd table. Then a Valid_If of:
ISBLANK([WorkshopComplete])
It doe sthe trick.
Glad you were able to find a solution.
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |