Re: how to fill a listitem based on a selection in another list item...Please help!!!!

One solution would be to change the record group to restrict it to a company chosen (if selected),
Then repopulate the record group, clear list, and repopulate the list.

Alter the boss record group query as follows:

'select b.bossname,b.bossnr from boss b,company c WHERE b.BOSSCOMPNR = NVL(:block.comany,b.BOSSCOMPNR)'

Add a when-list-changed trigger to the company list and add the folllowing:

declare
 rg number;
begin

• repopulate boss group rg := populate_group('boss_rec_grp_name');
  • clear boss list Clear_List('block.boss_list');
  • repopulate boss list Populate_List('block.boss_list', 'boss_rec_grp_name'); end;

"Maarten Martens" <maarten.martens_at_freebel.net> wrote in message news:g7ol9ts2sle1uk4v29tcqbelbqcot7rvrm_at_4ax.com...
> Hello All,
>
> I have a tough question. I included a jpg of the form I'm working on to
 give you
> people an idea. here goes :
>
> When the form is loaded, the three listitems are filled with records from
 the
> database tables. This all works just fine. When I press the button next to
> "company name", the list item activates and I can choose a company. The
 "boss"
> listitem is connected to the "company name" listitem. But it shows all of
 the
> names from it's table, not just the ones who are actually related to the
 choosen
> company. How can I fix this? I only want the boss names of the choosen
 company
> in the "boss" list item. I tried to change the query in the
 bossrecordset...
> something like "select bossname,bossnr from boss,company WHERE BOSSCOMPNR
 =
> COMPANY" but it just won't work. I hope there's anybody out there who can
 help
> me...
>
> Thanx in advance,
> Maarten
>
>
Received on Tue Feb 27 2001 - 02:08:13 CET