select the data to display

Hello everyone - new to appsheet, I have a question

I have several sheets in my application
1 Customers (a, b, c, d)
2 machines (1,2,3,4, …)
3 job

I have already made references between the different sheets that work

When creating a form for a new job, I find a drop-down list with all the clients
I select a client until everything works, in this same form I can also select from a drop-down list but in this list I find all the machines that are in my machine sheet.

I would only like the machines that are assigned to this client

Could you help me

Thank you

1 Like