Visio Data Graphics - Microsoft?

C

Callistus

I have an access database with business processes and the document(s) they
produce. One process may have one document, others more than one (in a
one-to-many relationship).

How can I connect visio to access to display that information without having
to manually de-normalize the database to show one row with document1,
document2, document3, etc?

If that is how it must be, is there a function or SQL statement to convert
the "many" side of the relationship into columns?
 
D

David Parker

Look into creating a Crosstab query in Access you can fix the column
headings for consistency
 

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

Opening document upon load Word 2007 3
thumb nail graphic of a Visio diagram (Visio 2007) 6
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
Database Model diagram 0
Creating ERD relationships in Visio 2007 1
Visio Database Stencils (ER Notations) 1
Data Graphics to display one-to-many relationships 1
Visio graphic changes depending on version 1

Top