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!