Using SELECT() to have a dropdown value

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!

Please post a screenshot of the error.

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])

3 Likes

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

2 Likes

All good now! thanks!