You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Dynamic Prompt Issue

1 reply [Last post]
Guest's picture
Guest

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.

Nitin's picture
User offline. Last seen 5 years 21 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Dynamic Prompt Issue

Do U really require Dynamic prompt here.. doesn't tools already support this by Keys where country is the Key in state table???

Thanks
Nitin