Re: LOVs & DROP DOWN Lists inf FORMS 4.5

Hi !

[Quoted] Ed Jennings <jenningse_at_mindspring.com> wrote:

>I have an item on a canvas that I want to use as a drop-down list.
>But I don't want the values hard coded in the form. I want an LOV
>that queries a table at run-time to populate the list. The problem is
>that I can only get a true drop-down list if I hard-code the values.
>If I try to use an LOV, I have to then put a button next to the item
>with a WJEN-BUTTON-PRESSED trigger. But this brings up a whole new
>window to display the list. I don't want that. I just want the
>vanilla pull-down list, dynamically built. Can this be done? Or
>am I asking too much of FORMS?

To fill a LOV dynamically with values from a database, using a record group is the best way.
You can write your SQL-statement in the record-group and then you can display the results in the LOV.

Hope this helps.

Greetinx from Patrick

--
Polizei SV Karlsruhe, Abtl. Tischtennis
http://psv-ka.home.pages.de