Hi Gediminas,

> Have 2 tables:
> Dances Classes
> Dance_ID Class_ID
> etc etc
> they are linked through the third table
> Class_Dances
> Class_ID
> Dance_ID

OK, table setup is clear. In Class_Dances you find which classes have
which dances.

> Now, I have a lookuplist, which points to Classes ( select * from
> Classes)

This is less clear to me. Usually when we talk about lookups, we mean:

looking up values in another dataset - the Lookup set - so the user
can select from them and assign that value to a field in the current
record of the "main" set - the KeySource set, in IBO terms.

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?


Greetings,
Paul Vinkenoog

(signing off for today)