Prabhu

• Sep 19th, 2006

 

In order to use a dynamic promt table; the field that is going to have the dynamic promt must point to a field in the DERIVED record. The promt table can be dynamically assigned with the following code.

If(condition)

%derivedrecordfield.value=promttable1

else

derivedrecordfield.value=promttable2

end-if;

People User

• Nov 13th, 2006

 

%edittype

Tej

• Feb 14th, 2007

 

This is the confusion that many people have. The Dynamic Prompt table is used when the prompt values are defined in the run time.Lets say if X = 1 then use 'EMPLOYEES' as the prompt table else use 'JOB' as the prompt table. end-if.Now in the record definition and record field properties you set the prompt table as %fieldnameThis fieldname can be any field name. (This is normally taken from a derived work record). This field should be placed on a page and make it invisble (usually).During the Row init.....you have to set a value to this field. This value will be the prompt record name. as long as this record is a valid one and the field contains a valid record name this dynamic Prompt table is used.Normally we use the field EDITTABLE as the Prompt table container...if the field is RECNAME then you should use %RECNAME instead of %fieldname.