Valid If in a ref column to show specific values

[Gregorrrry]

I have two tables Snagging and Project Admin.

Column ' Job Ref' in Snagging is a reference to the column 'Job Number' in Project Admin. Within Project Admin, there is another column called 'Type' and the values are either Client or Internal.

So, within Snagging I only want to show values in the 'Job Ref' dropdown when the related 'Job Number' is 'Client'.

I am struggling to work out the Valid If for the reference field.

[dbaum]

SELECT(Project Admin[Job Number], [Type] = "Client")

[Gregorrrry]

If I was to add another condition into the same expression, how would that work?

I'd like [Status] = Open to be added in as well as [Type] = Client

[dbaum]

Review the AppSheet Help article for the SELECT function that I linked to, as well as the AND article.

SELECT(Project Admin[Job Number], AND([Type] = "Client", [Status] = "Open"))

[Gregorrrry]

Thank you. I had the AND function at the front hence not working.