subfrom - many to many relationship

[ToniS]

I am trying to add a subform with in a subform and can not get it to work.
There are 3 tables involved, Exhibitors, ExhibitorsShows and
ExhibitorsRepGroup (used to handle
the many to many relationship between ExhibirorsShows and Exhbitors.
Fields for each table are as follows:

Exhibitors: ExhID, ExhShortName......
ExhbitorsShows: ExhShowID, ShowID, ExhID (Foreign key to Exhibitors)
ExhibitorsRepGroups: ExhRepGroupID, ExhShowID (Foreign key to
ExhibitorsShows),
RepresentedID (Foreign key to Exhibitors)


I am basically trying to get a subform to list who is representing them at a
show.
Example Data

Exhibitors tables (All Exh)

Exh 1
Exh 2
Exh 3
RepGroup1
RepGroup2

ExhibitorsShows (Exh going to current show)

RepGroup1
RepGroup2
Exh1
Exh2

ExhRepGroup (All rep groups and who they are representing)
RepGroup1, Exh1
RepGroup2, Exh1
RepGroup2, Exh2

End Result, main form is on Exh1 and subform or sub subfrom should display
RepGroup1 and RepGroup2
Main Form on Exh2 subform should display RepGroup2.


My subform I have the record Source set to the table ExhbitorsShows,
Link Child and Master Fields set to ExhID


the subform with in the subform I have the RecordSource set to the
ExhibotrsRepGroups
table. Link fields for master and child set to ExhShowID, I have the combo
box Row Source
set to the following "SELECT E.ExhID, E.ExhShortName, ES.ExhShowID
FROM Exhibitors E INNER JOIN ExhibitorsShows ES ON E.ExhID = ES.ExhID"

Any suggestsion/help would be greatly appreciated
ToniS