Select option according to the previous selection

[IssacGonzalez]

Hello partners,

I have a small problem that I haven't been able to solve.

I have 3 tables: Operators, Units and Trips.

In the Trips table I make reference in 2 fields to the other 2 tables, and what I would need is that according to the selection made by the operator, it shows me the unit that was assigned in the form when registering the operator

I share screenshots

 Operators table, Here, when adding an Operator is assigned a unit from the table of units that is referenced

 Units table

 Trips form, This is where according to the Operator selection, the next field that is unit would have to show me the assigned unit

[Suvrutt_Gurjar]

Since you are referencing the Operator table in the trip table , you could use dereferencing expression in the [Units] field to get it from the Operators table.

Dereference expressions - AppSheet Help