Only Show Action IF

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.

3 Likes

Glad you were able to find a solution.