I have a lookup field in my application (Customer)
I want when I select the customer, the rental order (also lookup) to be filtered such that the values are related to the selected customer
In the rental orders table, there's rental order id column with customer column
The rental order id cannot be repeated but for different rental orders we can have the same customer
All I want to do is when the user selects the customer, all the rental orders related to this customer only will be in the lookup of rental order
I am doing it through web services in power apps (javascript)
Thank you in advance