Hi,Could someone help me understand the concept and solve my below problem?
I have a Two tables
1. VehicleTypesField Id category1 Cars2 Buses3 Trains
2nd table SubVehicleTypes
SubID Id SubCategory1 1 Sedan2 1 Suv3 2 Luxury4 2 Semi luxury5 3 Ac Trains6 3 Non Ac Trains
Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2
When I select category from DD1 the second DD2 should give Subcategory based on ID(Common in both Tables).
ThanksFaisal
Discussion posts and replies are publicly visible
This is my Raw code
a!localVariables( local!vehicleTypeData:rule!FF_Exp_VehiclesTypes(VehicleId:null), local!vehicleSubTypeData:rule!FF_Exp_VehiclesSubTypes(subId:null), local!vehicleType, local!vehicleSubType,{ a!dropdownField( label: "Dropdown", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!vehicleTypeData.category, choiceValues: local!vehicleTypeData.id, saveInto: {}, searchDisplay: "AUTO", validations: {} ), a!dropdownField( label: "Dropdown", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!vehicleSubType, choiceValues: local!vehicleSubType, saveInto: {}, searchDisplay: "AUTO", validations: {} )})
I'd suggest looking at the docs page for cascading dropdowns. Basically you will need to filter the results of your second list based on the selection from your first list, so you'll need a query that filters your sub-category by the category provided.