Filter for Dynamic List

[juned_seskoad]

Dear Sir,

I have a table list of all entities with type, C=Customer, S=Supplier, U=User.
then I made Dynamic List for Entities, but how to make a filter to show list of Entities Table, sample in field Customer if I click drop down list will fill just Entities data with Customer type, in field Supplier if I click drop down list will fill just entities data with Supplier type

Please guide me to do this

Regards

Juned

[Jon]

Add the type to your Dynamic List e.g. add a List field named TYPE and click the Required checkbox. Add TYPE=&&TYPE to the where clause of the Dynamic List.

I assume that you already have a form field or table column that contains your type code, if not create one. Let's assume this form field is named TYPE.

Now click on the Dynamic List Mappings property for the form field where you have the list. This will show a panel mapping list fields to form fields. Under Additional list fields, map the list's TYPE field to the form's TYPE field ( the system may do this for you automatically as soon as you open the dialog panel).

Regards
Jon