At 2003.08.24 00:51, you wrote:

>Is this what you want - so the user can choose a dance to assign to a
>class? Then you need a KeySource-Lookup relation. We can explain more
>about this if this is really what you want and you don't get it to
>work.
> > In listbox I want to have a list of dances, which are in selected
> > class
>This sounds more like:
> I want a list showing the dances that the currently selected class
> has.
>If this is what you want, that's Master-Detail. The list you talk
>about would usually be an IB_Grid.
>
>Please tell what you would like to show on screen, and what you would
>like your users to be able to do. Maybe you want both a lookup
>possibility and a master-detail?

I want the both possibilities - at first user can look, what dances are in
the selected class (master-detail as I understand). Then, user can change
dances (add/remove), which are assigned to the selected class (this is
keysource-lookup)

I'm using
ClassQry->ClassDS->DanceLookupList
ClassQry->SQL=select "Class_ID" , "Brief_name" from Classes
DanceQry->DanceDS->DanceListBox
DanceQry->MasterSource=ClassQry
DanceQry->SQL=select "Dance_ID" , "Name" from Dances
set MasterLinks..




--/ Gediminas /--
The Truth Is Out There