Filter Combo List based on the Selection in Another Combo

Yahoo Archive
1
Hi,
Thanks for the below

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Dont know what version you are on, but in 8.03.405 I would add an
> event handler for the before dropdown event for list 2. In there I
> would do a list lookup on CustCnt and create the whereclause using
> the selected value from list 1 and bind the resulting data to the
> combo - you can set up your column filters so you only display the
> columns you want in the form load event.
>
> bw
>
> --- In vantage@yahoogroups.com, "brychanwilliams"
> <brychanwilliams@> wrote:
> >
> > Good afternoon,
> >
> > I have a combo(list1) which lists customers . I would like to
have
> > another combo list which contains only the contacts(list2)
related
> to
> > the customer selected in List1.
> >
> > A database field will get populated on daving but most of the
> > interaction will be in the user interface.
> >
> > Prsently, I have an ultracomb attached to the customer adapter to
> list
> > the customers(list1).
> >
> > I have a combo listing customer contacts but I can't work out to
> filter
> > that depending on which customer is selected. I can filter combo
> (list2)
> > fixing the custnum but not on the selection.
> >
> > Any help would be great.
> >
> > Many thanks
> >
>
2
Good afternoon,

I have a combo(list1) which lists customers . I would like to have
another combo list which contains only the contacts(list2) related to
the customer selected in List1.

A database field will get populated on daving but most of the
interaction will be in the user interface.

Prsently, I have an ultracomb attached to the customer adapter to list
the customers(list1).

I have a combo listing customer contacts but I can't work out to filter
that depending on which customer is selected. I can filter combo(list2)
fixing the custnum but not on the selection.

Any help would be great.

Many thanks
3
Dont know what version you are on, but in 8.03.405 I would add an
event handler for the before dropdown event for list 2. In there I
would do a list lookup on CustCnt and create the whereclause using
the selected value from list 1 and bind the resulting data to the
combo - you can set up your column filters so you only display the
columns you want in the form load event.

bw

--- In vantage@yahoogroups.com, "brychanwilliams"
<brychanwilliams@...> wrote:
>
> Good afternoon,
>
> I have a combo(list1) which lists customers . I would like to have
> another combo list which contains only the contacts(list2) related
to
> the customer selected in List1.
>
> A database field will get populated on daving but most of the
> interaction will be in the user interface.
>
> Prsently, I have an ultracomb attached to the customer adapter to
list
> the customers(list1).
>
> I have a combo listing customer contacts but I can't work out to
filter
> that depending on which customer is selected. I can filter combo
(list2)
> fixing the custnum but not on the selection.
>
> Any help would be great.
>
> Many thanks
>