IMO, what it does is builds a report that doesn't quite match what you see in the relationships window. It doesn't even print it -- it creates a report. Just like other wizards.
IE it's the tacked on Print Relationships Wizard that was added to Access 97 AFTER people complained that there was no functional print command to print the relationships at all. Microsoft just tacked on this wizard into the subsequent versions of Access... instead of working to make a functional print command that actually can scale exactly what you see in the relationship window and actually prints it to fit on the number of pages you want to give it... in landscape or portrait.
mebbe theres something odd going on then
yes it is a report, who cares..... you can then print that report.
it does allow multi page printing
it does allow portrait or landscape
it does expand to show all columns in a table
and it does look very similar to the layout in the relationships. yes its flawed, yes its not as immaculate as I'd like it.. but it is what you've laid out int he relationships window
If you change relationships you have to generate a new report
you can't edit that report because all the lines and boxes aren't linked, so any changes don't keep the RI links assoicated with the object, but its a freebee.
it aint perfect.. but it does print the relationships
I'd prefer to have a full data modelling tool layout on A0 paper, but theres lots of things that I'd like, they are not always a good idea or costg effective, or even available.
If I want a prettier report and the customer doesn't have suitable modeling tool then I'd gen a report using Visio and reverse engineer the db
But I suspect for most people using Access, and by default using JET tables, will be happy enough with the result formt Print Realtionships
Sure, and it's up to each individual to choose what is better for their needs. Each method has it's advantages. I'll always choose the Printscreen - Paste method when the entire ERD can be seen on one screen.
My point was simply that the so called File - Print Relationships command DOESN'T quite do what it says "on the tin"
I also thought it might be worth mentioning the history behind it to show why the command has such glaring flaws... and why you don't get a print dialog box when you choose File - Print... and why there is no File - Print Preview.