Dear Guru's,
Could you help me with the following task?
I have two tables, where Table1 called "auto_info" and contains the following information:
----------------------------------------------------------------------------------
id | Truck_number | driver_id | trailer_id | carrier |
--------------------------------------------------------------------------------
5 FX9784IB 3 4 Carrier 1
3 FX9765IB 2 3 Carrier 1
Second table called "driver" and contains the following information:
----------------------------------------------------------------------------------
id | Driver_licens | FirstName+LastName | phone_number |
--------------------------------------------------------------------------------
2 TXB117925 John Wayne Carrier 1
3 XPB976547 Kody Brown Carrier 1
Note: auto_info.driver_id = driver.id
When im start writing information into Text Input field Truck_number (e.g. "FX97") records in Table 1 automatically filtering and return list of results.
I need to filter second table "driver" based on filtered result taken into account that auto_info.driver_id = driver.id
I tried to use Filter(auto_info,driver_id = driver.id,id) but it return delegation warning
Delegation issue is important to be resolved in solution.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional