Announcements
No record found.
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
Use the dex add item command to populate the ddl. Dex help is your friend!
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/.../
Thanks for your response.
Please show me some working example related to this scenario.
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 692
André Arnaud de Cal... 532 Super User 2026 Season 1
CP04-islander 478