Hi Fellow Focus Users!

In the Apps Studio html page, I have no problems adding a dropdown and showing 2 columns... for example, account numbers and their descriptions. See first image.


But how can I do the same in the new 8202 New Page option? I use

WHERE PAYROLL_VIEW.COSTCENTRE_DIMENSION.COSTCENTRE EQ &OVCC.(OR(FIND COSTCENTRE IN PAYROLL_VIEW.COSTCENTRE_DIMENSION.COSTCENTRE)).COSTCENTRE.;

to show the dropdown and that works but how can I add the Description for each of those accounts, just like in the html version? Note: The description is in the same table. See second image


Any help appreciated! Thanks

This message has been edited. Last edited by: FP Mod Chuck,

create a define field in master file doe id+ desc,
then when you will create Where clause using GUI it prompts 2 options in last to pic the display field and value field in display choose define filed and in value pass the ID field.

Thanks Chaudhary, I was able to get what I wanted.