many-to-many relationship in reports

I

info

You can find plenty of info on linking many-to-many relationships in
databases (using junction tables), but is there a way to output the data in a
report, colating the data as follows:
Service Servers
_________________________________________
IIS Server1
Redwood Service Server2
FTP Server3
Server4
Server5
 
J

John Vinson

You can find plenty of info on linking many-to-many relationships in
databases (using junction tables), but is there a way to output the data in a
report, colating the data as follows:
Service Servers
_________________________________________
IIS Server1
Redwood Service Server2
FTP Server3
Server4
Server5
Click to expand...

Yes; base the report on a Query joining the three tables, and use the
properties of the textboxes to hide duplicates for the Service.

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