Change the value of a combobox, when another combobox is changed?

I have a combobox for Equipments, and when I choose some value I need that Area and Station changes too. (Area and Station are combobox too)


My entity Equipment has: Id, EquipmentName, StationId and AreaId. (Station and Area are coming from statics entities as foreign keys).


How can I get the area and station when the equipment changes?


 

Solution

Hi Julia,

In the preparation, make an aggregate for each query, with the IDs filters.

And in the Equipaments combobox properties, set a OnChange and in this action use a refresh data statement and an Ajax refresh to update the screen.

Solution

Follow a .oml sample

Leandro Correa wrote:

Hi Julia,

In the preparation, make an aggregate for each query, with the IDs filters.

And in the Equipaments combobox properties, set a OnChange and in this action use a refresh data statement and an Ajax refresh to update the screen.


Thank you so much, it worked! And thank you for the sample.