Hello, I have a slice, and need to limit the ...

Hello, I have a slice, and need to limit the rows in it shown by a value in another table.

Table 1:

Job Assignments

Table 2:

Job Updates

A virtual column in Job Assignments links to a table called Job Updates by a ref, and a bunch of de-refs, which carries over a unique key

I need a slice which only shows rows from table 1 if a column in table 2 shows or doesnโ€™t show a certain value.

Basically, in Job Updates, when [Job Complete?] is marked as โ€œTRUEโ€, I need it to no longer show the row in the slice of job assignments

Thanks in advance for any help

0 9 390
9 REPLIES 9
Top Labels in this Space