Select from a dropdown with condition from a third table

[admEmaterce]

Hi, Everyone.

I'm developing an app on appsheet to control some projetcs.

On this app, I have 3 tables. First one with employee data (id, name, city, region, etc...), the second table with client data (id, name, city, region, address, etc...). The third table contains a dropdown with the name of the employee (ref to table 1), the name of client (a ref to table 2).

The problem is: on the third table i want to filter only the clients that are on the same region as the employee. So I created this expression on Valid_If field:

SELECT(ClientTable[Name],[Region]=[_THISROW].[Employee].[Region],TRUE)

It's "working".. Appsheet is returning a list on the dropdown with the clients on the same region as the selected employee (this is what I want). BUT, the list of client come with an exclamation mark after the name. And this issue is blocking other columns that depends on the selected client name in the third table.

Can anyone help me with this issue?

Thanks!

[Marc_Dillon · Accepted solution]

[Name] isn't the key column of your clients table is it?

Switch the "SELECT(Client[Name]" to "FILTER(Client"

[admEmaterce]

Hy Marc,

No, name is not the key column! The key column is a unique number, like social security number in US.

But I set Name as a label.