Re: how to populate a list with a dynamic query

You need 2 columns for a listbox. Then just use:

rg_id := populate_group_with_query(group_name, your select statement); populate_list(list_name,rg_id);

This should work.

Steve J.

Mohamed Mahfooz wrote:
>
> Hi everyone,
> I have a form that has two related fields, dept and contact. The contact
> field lists all the employees in the each dept. What I want to do is to
> populate the contact field with the appropriate list according to the value
> in the dept field, that is, I will need to create a record group
> dynamically. I have tried several ways but I couldn't get a result, any
> help will be appreciated.
>
> regards,
> mohamed mahfooz
> Dubai Public Prosecution
> Programmer
  Received on Tue Nov 11 1997 - 00:00:00 CET