Select from different customer list tables

[DEVIMPLOY_Autom]

hello, I have two tables, the main one of customers (group) has the list of all [id_adr] in the user table has only the [id_adr] that belongs to the seller.

What would you like to see only the [id_adr] that belongs to the seller

 

[Joseph_Seddik]

Dependent drop-downs - AppSheet Help 

[DEVIMPLOY_Autom]

what I need is to create a view in the TABLE GROUP has all ID_ADR , the seller has some ID_ADR . what do I need the app to look at in the seller's table compare and bring only the GROUP that correspond to the seller

[DEVIMPLOY_Autom]

 

hi i have three tables.
The cad_group table is the main one, then the cad_farm and the user table is just his information.

what I'm looking for is to filter or select only the groups that are equal to the user's adr_id .

I think it would be possible to use cad_farm as a comparison but it may happen that the group repeats

so , if in the cad_group only the groups that are equal to the ID_ADR of the user appear , that solves the problem .