Hey hi I am just working with Dynamic prompt my requirement is

> When I select country name from ddl i.e India, In the next state field I want to get prompt table regarding indian states

> When I select country name from ddl i.e usa, In the next state field I want to get prompt table regarding usa states

For this I have created two views on PS_STATE_TBL , to use for prompting

india
SELECT DESCR FROM PS_STATE_TBL WHERE COUNTRY ='IND';

usa
SELECT DESCR FROM PS_STATE_TBL WHERE COUNTRY ='USA' AND DESCR NOT LIKE '%tax';
>>Next I have written the following code in FieldChange event

Evaluate DYNAMIC_TBL1.COUNTRY1
When "I"
DERIVED.EDITTABLE = "RECORD.INDIA_PROMPT_VW";
Break;
When "U"
DERIVED.EDITTABLE = "RECORD.USA_PROMPT_VW";
Break;
When-Other
End-Evaluate;

But from the front end I am getting the following error message
Prompt table in the DERIVED.EDITTABLE is not available. (4,3)
the prompt table for the field for the field is controlled by the contents of another field. this controlling field is not included in the component.