Link subform via an intermediary table

[btrini10]

Hi all

I am trying to include a subform on my main form but the two forms a linked via an internediary table. The main table contains cases that we are working on while the sub-form contains contacts associated with the cases. I have a many to many relationsip between the two forms since any contact can be associated with any case. I have a seperate table joining them that allows for a one to many and many to one relationship.
Is there a way for me to show on a case form, which uses the case table, all associated contacts via a subform.
Any ideas would be helpful.
Hope this makes sense.

 

[PWise]

main table
caseid
....
....

Contact table
contactid
Contactname
.....



Case Contact table
caseid
contactid

Select caseid ,contactid,Contactname....
From Case Contact
inner join Contact table
on Case Contact.contactid = Contact table.contactid
Group by caseid ,contactid, Contactname

 

[btrini10]

Thank you. Did not think of creating my sub-form based on a query.