You create a dynamic prompt the same way you do for a regular prompt BUT instead of writing the record name behind the record field properties, you write %EDITTABLE (see picture below). Then you would need to assign your "EDITTABLE" variable a value (your record name) using PeopleCode depending on some criteria you choose.

A sample code could look like this:

Thank u lepa ,from this i get a clear idea of dynamic prompt table

One addition to above reply from Lepa , You also have to add the field DERIVED.EDITTABLE to the page where dynamic prompt record is there and make it invisible
or
else you will get the error (GetField: Field 'DERIVED.EDITTABLE' not found in scroll level 0. (2,155) )

thank u simrose

Does it worked - Mahesh??

where we can place this peoplecode code?

compoment.record.fieldchange (.DERIVED.EDITTABLE.FIELDCHANGE) is the best place to right the code

Has anyone figured out how to use the SetEditTable function with out put the DERIVED.FIELD on the page. PeopleBooks states that it is doable but I've not been able to get it to work. They solution listed above in this thread works great but for current my usage I really need to be able to change the prompt table with out adding the field to the page.

This is what my codes looks like so far

Local Record &REC;

&REC = GetRecord(Record.RC_PAYINIT);
&REC.SetEditTable("%EDITTABLE", Record.ZG_PAY_RUN2_VW);
&REC.ExecuteEdits();

Any help will greatly be appreciated...