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"



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