Finance | Project Operations, Human Resources, ...

How to show GP items in dexterity dropdownList

(1) Share

Report

Posted on by AyyazKhNA

I just created a simple window in which i have two fields .

1: Description text box.

2: DropDownList for items from GP.

I want to show the list of items from GP in a dropdown which is created by using dexterity.

Any who can precisely guide me for the expected solution.Thanks

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Suggested answer

David Musgrave MVP ... 13,982 Most Valuable Professional on at

Like (0)

Report

RE: How to show GP items in dexterity dropdownList

This will work, but as Drop Down Lists are limited to 32K items you will have issues of there are too many records being added. Also anything more than around 20-30 items and using a Drop Down List is not the best user experience.

clear '(L) DDL Field';

get first table IV_Item_MSTR;

while err() <> EOF do

add item 'Item Number' of table IV_Item_MSTR to '(L) DDL Field';

get next table IV_Item_MSTR;

end while;

'(L) DDL Field' = max(1, '(L) DDL Field');

David
Suggested answer

SMike Giuffre 277 on at

Like (0)

Report

RE: How to show GP items in dexterity dropdownList

There are working examples in the Dex help system, which is why I recommend it so strongly. These examples related directly to the Dex Sample applications delivered on the installation media.
AyyazKhNA 5 on at

Like (0)

Report

RE: How to show GP items in dexterity dropdownList

Thanks for your response.

Please show me some working example related to this scenario.
David Musgrave MVP ... 13,982 Most Valuable Professional on at

Like (0)

Report

RE: How to show GP items in dexterity dropdownList

Mike is correct, to dynamically build a drop down list use the add item command.

To have static values, add them when you create the datatype for your field.

If you need more information on Dexterity and training see

winthropdc.wordpress.com/.../

winthropdc.wordpress.com/.../
Suggested answer

SMike Giuffre 277 on at

Like (0)

Report

RE: How to show GP items in dexterity dropdownList

Use the dex add item command to populate the ddl. Dex help is your friend!