I have to Lookup fields. One where I can select Vehicle type. When I select one vehicle type in the lookup I want the second Lookup to be filtered according to Vehicle type lookup.
The query I have created is as follow but is not working.
select e from fleetmanager$Model e
where e.make.id = :ds$makesDs.id
and (e.vehicleGroup in (:component$fieldGroup.vehicleGroup))
I need help with this same problem, but I don’t know how to solve it, where do I put this query? I need to filter a lookup based on the value of another lookup (countries and cities)