Re: LOVs & DROP DOWN Lists inf FORMS 4.5

Here's what I think you're looking for. You can dynamically create a drop down list. You'll need to create a record group with 2 columns. One for what's displayed and the other for the value of the item. Then use thet "Populate_List" built-in and reference your list box and the record group created on the fly. When creating the record group don't forget to populate it.

Hope this helps

Steve J.

Patrick Mueller wrote:
>
> Hi !
>
> 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
  Received on Wed Mar 25 1998 - 00:00:00 CET