Using SELECT() to have a dropdown value

[MEC]

Hi!

I’m trying to have a dropdown value list based on a value entered. I’m using the below expression

SELECT(Loan[PN no.], [Client full name] = [Payment].[Client name])

But I’m getting error. Basically I want to have a list of “PN no.” from a LOAN table based on the “Client name” entered in the payment table. Appreciate any help!

Thanks!

[Steve]

MEC:

But I’m getting error.

Please post a screenshot of the error.

[MEC]

All good now! thanks!

[Mark_Taylor · Accepted solution]

Are you putting that into the Valid IF or Formula?

I have achieved this with the select entered into the Valid IF

With this
SELECT(Loan[PN no.], [Client full name] = [_ThisRow].[Client name])

[MEC]

Hi Mark. It’s working well now. Thank you! I think I need to study [_ThisRow].