Dynamic Prompt

Dynamic Prompt Tables:

Nothing but getting list of values from a at runtime.
The angular brackets mentions that the record from which values are fetched is substituted runtime.

This is achieved using %EDITTABLE as the Edit table in the Record Field properties of the field which should show values.
%EDITTABLE is replaced with actual record at runtime.

Lets see some scenarios in which we can use Dynamic prompt.
1)  Depending on the type of User, say Employee should see data from one record and if it is manager, he should see the data from another record.
2) In a grid/page , where depending on the value of one field , the prompt values in another field changes.

Demonstration in next post.