Share
ReportHello
I have a entity which contains vehicle data. The columns include vehicle type, number of wheels , vehicle name etc. I have this linked to another table using a lookup relationship. So a support request can relate to a specific vehicle. Now this all works fine. The problem that i am having is that the default lookup view is not good at all. we have thousands of vehicles in our entity and using the standard lookup is unfeasible.
The requirement that i have is to make a sort of a progressive menu to pick the vehicle. For example we have a drop down that has all vehicle types. Then when you select the vehicle type, the second drop down which would be number of wheels is only populated with the vehicles of that type. So once you select 4 wheels , it will show only vehicle names with 4 wheels and of type that you picked in the third drop down and so on. I am not sure how to create this effect with dynamics. i know how i would do it with Microsoft access or other databases.
Essentially i would have to on load run a query to populate the option values of the first drop down with (select * vehicle types from VehicleTable) and on the on update event of the drop down , i just run a query to populate the second drop down list options eg select * from vehicleTable where vehicle type = my vehicle type. and so on.
I am not sure how i can create this effect with dynamics. Can someone provide me with some insight as to what direct i need to take to generate this effect?
*This post is locked for comments
All responses (
Answers (
30,188
