At 11:50 PM 23/08/2003 +0200, you wrote:

>Have 2 tables:
>Dances Classes
>Dance_ID Class_ID
>etc etc
>they are linked through the third table
>Class_Dances
>Class_ID
>Dance_ID
>
>Now, I have a lookuplist, which points to Classes ( select * from Classes)
>In listbox I want to have a list of dances, which are in selected class
>How this to set? I have tried using mastersource/masterlinks, but without a
>success
>
>I guess, that I need to implement such SQL code:
>select d."Name"
>from Dances d, Classes c, Class_Dances cd
>where c."Name"='E4' and c."Class_ID"=cd."Class_ID" and
>cd."Dance_ID"=d."Dance_ID"

Which components are you using for data access?

Helen