Subform in many-to-many-linked-table

[obs]

Hi all,
I have two tables that are connected in a many-to-many link.
I want to put a subform in one of the tables, but somehow the subform does not show any information where it should.
The two tables are linked using another table.
What is my possible mistake ?
Plz help ASAP !!!

 

[dcobau]

you cannot put a subform in a table! subforms are placed on forms.

Dave

 

[boblarson]

Dave hit it on the head - subFORMS are just that Forms that are under the main form.

 

[obs]

What I meant was, that I put the subform in a form which represents one table.
What is the way to use subforms in many-to-many connection ?

 

[boblarson]

To be able to have a better idea of what to answer there, can I ask what each table is and what makes it many-to-many? I just want to understand what you currently have so I can help figure out a good way to suggest.

 

[obs]

Thanks for the reply Bob,
Table 1: Gallery
Table 2: Artist
-- an artist shows his work in more than one gallery.
-- a gallery shows the work of many artists

I created a special link table which contains two primary keys:
one is the artist id and the other is the gallery name, both of which are the primary keys in the Gallery and Artist tables.

So I tried to put a subform which presents all the artists of a certain gallery in the Gallery form I created.
It simply didn't work when I tried to use the Artist table in the subform creation wizard.
The thing that did work was when I used the link table in the wizard , but the problem in that was that I could only show the two fields(Artist ID and Gallery name).

Is there something I'm missing here about subforms and many-to-many tables ?