Hide rows Values IF they equal a value

[BlakeHammond]

Hi

I am trying to hide a row value so it doesn’t appear in a table lookup. I will explain

I have A app called Live orders and a newly created app call job sheets.

In job sheets app i create a new job by selecting certain details from the live orders app. Like Job Number Customer Name ETC

When I mark that job as complete it still appears in the list of orders i can select. I would like the list only to be orders that are not complete.

I tried using filter or select but I could only get them to work if the column is the key. which it isn’t

Blake