How to list values in combo box, based on priority field increasing order.

Hi Experts,

Currently I have two Combo box called Area and SubArea. Second combo box’s list value changes based on the value selected in ‘Area’ combo box. Below is the value given in subarea’s property window.

Value list Condition :  select( "subarea", "tablename", "area", [AreaID], "activestatus", true)

But the value in the subarea is listing in alphabetic order.

My requirement is to display the values based on a field called ‘priority’, this field contains numbers starting from 1 to 5. So values in subarea should be listed based on priority increasing order.

Any suggestions are appreciated.

Thanks & Regards,

Jithisha