Let say the value &categ is taken from this field EXO_CUST_DYANM.EXO_CATEGORY_K. Then you should be having a control table for category or as Xlat values in PSXLATITEM table.

You can create a rowset for this control table or PSXLATITEM table. Loop through the rowset. Pass on the values to the condition as like below.

For &t=1 to Controltable rs.Activerowcount
if controltable rs(&t).EXO_CATEGORY_K.value=EXO_CUST_DYANM.EXO_CATEGORY_K then
EXO_CUST_DYANM.EXO_MODEL_K.SqlText = "SELECT EXO_MODEL_K ,EXO_CATEGORY_K FROM PS_EXO_MODEL_PROM WHERE EXO_CATEGORY_K=:1"|controltable rs(&t).EXO_CATEGORY_K.value;
end-if;
end-for;
Let me know if this solves your purpose.

Regards,
Hari.A

To fill the value on one field based on the value of another we have two options.

One option here is to create a sql with text

SELECT EXO_MODEL_K ,EXO_CATEGORY_K FROM PS_EXO_MODEL_PROM WHERE EXO_CATEGORY_K= :1

then in the field change of category write the code to fille the data in the model field by passing the selected category value to the dynamic SQL.

second option is to create 2 sql views one with a key field and category code and another with key field category code and model then place the model immediately after category code........

Thanks,
Prashob