How do I view data in a subfrom with a many to many relationship?

D

ddjackso

I have a database with tables that have a many to many felationship through
junction tables. The main form I have shows information from "table1" and
has a subform with information from "table2". When I scroll through the
records in the main form "table1" all I can see change in the subform is the
information for the junction table. How do I see the information of "table2"
change in the subform when scrolling through the information in "table1" in
the main form?

Thanks
 
J

John Vinson

I have a database with tables that have a many to many felationship through
junction tables. The main form I have shows information from "table1" and
has a subform with information from "table2". When I scroll through the
records in the main form "table1" all I can see change in the subform is the
information for the junction table. How do I see the information of "table2"
change in the subform when scrolling through the information in "table1" in
the main form?

Thanks
Click to expand...

Base the Subform, not on the junction table, but on a Query joining
the junction table to Table2; or, rather than using textboxes for the
ID fields in the subform, use Combo boxes which are bound to the ID
fields but which display the text from Table2. See the "Orders" form
in the Northwind sample database for an example.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top