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!!!