Can someone please help me out?

in Acces i have created the next three:docent, student, module. The save the connections i have also created the forth table "moditems".

"select m.* from moditems as mi,Docent as d, module as m where m.id=mi.modid and mi.docid=d.id and d.id="&id&"",cnDB,0,1,1

I have tried, just to see if the two connections seperatly would work. so first i connected the first table "docent" with "moditems". this worked. Then i tried to connect the "moditems" with "module". but this one didn't do.

this realley kicks my ass

please help me out!!!

Did this ever get resolved?