Hi Russ,

You can create Dropdown list based on an array.
To do that, at first, create an array MyArray :

Select filed1 from MyTable Into array MyArray
if _tally = 0
Declare MyArray[1]
MyArray[1]="Nothing found"
endif

Then in form designer create a Dropdown list having Array Popup as a source and "MyArray" as an array name.

BTW you can try to use List popup which has a lot of more options (array, popup, files, field, DBF structure).

Igor Gelin

>Hi
>
> I'm having a problem creating a Dropdown list in the FPW screen designer in that it's options are limited. I would like the list to come off 1 field from a table or cursor. In DOS this could be accomplished using 'Define Popup... prompt field ...'. Any help would be appreciated.
>
>Thanks
>
>Russ