many-to-many relationship in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import to many to many table 7
Many-to-Many Relationship 13
Understanding Many-to-Many Relationship 4
Determine IP address of Network Load Balanced server at runtime 5
Event 1586 on a Domain Controller 1
Implementing a many-to-many relationship 4
Help with for loop 1
Database design many to many relationships 4

Back
Top