Re: Relationships. Does anyone use them?

Hi, Stephen.

Cool! You have the niftiest tools on your Web site! Thanks for making them
available to the rest of us.

I look forward to your next release. The sooner the better!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
wrote in message news:rqR4g.571$A26.15468@xxxxxxxxxxxxxxxxxxxxxxxxxx
Gunny I also have another Relationship window tool in the works. I nearly
finished it several weeks ago but work in the real world caught up to me.
The solution was originally built for developers who defined a
Relationship window view that would not fit onto the max page size width
supported by the Access report object(22.75 in).
Basically, I recreated the view in the Relationship window within a PDF
document. I chose a PDF doc as you can easily send a PDF to a printing
center to be rendered on a plotter or the use the native scaling props of
a PDF reader app to output the doc to the page size of your choosing.

Allen Browne's code is used to show the properties of each relationship,
table field size etc.The two most difficult issues were the logic behind
the rendering of the Relationship Lines and creating logic to move/place
and size individual Table windows so that all fields are visible(even if
they are not in the Relationship Window view). These two issues are
completely intertwined and took several days to solve.

I should find time to finish Beta testing next week.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:vomdnWYSZPGoWc7ZRVn-qQ@xxxxxxxxxxxxxxx
Hi, Ken.

One of the "features" that I wish ACCESS would do is to remember the
organization of the Relationships window when one imports a database
into a new one (which is one way of fixing corrupted databases)

It doesn't seem like it would be that difficult to program this into
Access, does it? Oh, well. At least we have the built-in Print
Relationships tool, so Microsoft has been making some effort into making
database documentation a little easier.

If you don't have access to professional E-R diagram software, then the
Relationships window is the only way to see the table and query
relationships. When you have your tables arranged correctly, use Stephen
Lebans's tool to save the current Relationship View in a table. That way
you can restore that same view to the current database or to any other
database you import these tables into. As Allen Browne mentioned in a
previous post, you'll find Stephen's tool on the following Web page:

http://www.lebans.com/saverelationshipview.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Ken Snell" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:c7OdnQ-4Kt3vJs7ZnZ2dnUVZ_vWdnZ2d@xxxxxxxxxxxxxx
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:4sWdnVHJKYBgMc7ZnZ2dnUVZ_t-dnZ2d@xxxxxxxxxxxxxxx
Hi, Salad.

Over time I'd go into the window and see relationship
spaghetti....tables/queries all overthe place with lots of
relationship lines between here and there.

It's up to you to organize the positions of the tables in that window.
If it looks like a mess of spaghetti, then take a few minutes to
organize it better. As the database designer, you're in charge of
this.


One of the "features" that I wish ACCESS would do is to remember the
organization of the Relationships window when one imports a database
into a new one (which is one way of fixing corrupted databases)....
after doing this many times during development, I've just "given up" on
redoing the window each time, until I have "finished" the database (of
course, with my "biggest" application, it seems I'm continually adding
new features as soon as one is done, so...... < g >)

--

Ken Snell
<MS ACCESS MVP>








.

Relevant Pages

  • Re: Relationships. Does anyone use them?
    ... If I have EmpId in Employees, and EmpID in table Orders, if I add ... Relationship window and set relationships? ... Sounds like you've never done any formal database design? ...
    (comp.databases.ms-access)
  • Re: Relationships. Does anyone use them?
    ... If I have EmpId in Employees, and EmpID in table Orders, if I add ... Relationship window and set relationships? ... Sounds like you've never done any formal database design? ...
    (comp.databases.ms-access)
  • Re: Associating records in same table.
    ... How big is your database? ... Open the Relationship window, put the table twice in the window (Access ... It sounds like both you and Gina are suggesting that, ... that I would need to set up a junction table between two ...
    (microsoft.public.access.forms)
  • Re: Relationships. Does anyone use them?
    ... I recreated the view in the Relationship window within a PDF ... organization of the Relationships window when one imports a database into ... database documentation a little easier. ...
    (comp.databases.ms-access)
  • Re: Relationships. Does anyone use them?
    ... why do I need to add 2 tables in the Relationship window and set relationships? ... If you do not care to "go in into the relationships window to set the relationship" you are, quite simply, going to fail badly any relational database course. ... When a database application gets large and widely used, the following is an example of what happens that simply screams for the lowest level constraints to be used. ... You really need to go over this in detail, because right now I can tell you, no offence intended and with the greatest of respect, that you are NOT DOING RELATIONAL DATABASE DESIGN WORK at present. ...
    (comp.databases.ms-access)