Professional Web Applications Themes

MS-ACCESS Relationships = SQL Views, right ? - MySQL

I've used MS-ACCESS quite a bit in the past and I find the RELATIONSHIPS functionality really usefule...now I've grown up a bit and am getting to grips with SQL. Newbie question....MS-ACCESS Relationships are the same (kinda) thing as SQL Views, right ? TIA Nick...

  1. #1

    Default MS-ACCESS Relationships = SQL Views, right ?

    I've used MS-ACCESS quite a bit in the past and I find the RELATIONSHIPS
    functionality really usefule...now I've grown up a bit and am getting to
    grips with SQL.

    Newbie question....MS-ACCESS Relationships are the same (kinda) thing as SQL
    Views, right ?

    TIA
    Nick


    NA Guest

  2. #2

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

    NA news wrote: 

    Nick,

    Not at all. Relationships are equivalent to foreign keys in SQL. There
    isn't an exact equivalent in Access to SQL views, although reports come
    closest.\

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

     

    Thanks, Jerry, that's a lot clearer now....

    I'm looking at using NaviCat but I can't seem to find the functionality of
    displaying the relationship diagram (ERD) ... do I need a separate tool for
    that ?


    NA Guest

  4. #4

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

    NA news wrote: 
    >
    > Thanks, Jerry, that's a lot clearer now....
    >
    > I'm looking at using NaviCat but I can't seem to find the functionality of
    > displaying the relationship diagram (ERD) ... do I need a separate tool for
    > that ?
    >
    >[/ref]

    Sorry, I don't use Navicat, so I can't help you there.

    I normally make my own diagrams in Visio.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  5. #5

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

    On Sun, 18 Feb 2007 09:50:36 +0000, NA news wrote:

     
    >
    > Thanks, Jerry, that's a lot clearer now....
    >
    > I'm looking at using NaviCat but I can't seem to find the functionality
    > of displaying the relationship diagram (ERD) ... do I need a separate
    > tool for that ?[/ref]

    Doesn't Access use the relationship diagram just for predicting the right
    joins to use when building queries in the designer?


    Pete Guest

  6. #6

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

    Pete Jewell wrote: 
    >> Thanks, Jerry, that's a lot clearer now....
    >>
    >> I'm looking at using NaviCat but I can't seem to find the functionality
    >> of displaying the relationship diagram (ERD) ... do I need a separate
    >> tool for that ?[/ref]
    >
    > Doesn't Access use the relationship diagram just for predicting the right
    > joins to use when building queries in the designer?
    >
    >[/ref]

    That's true - a foreign key is really a lookup table in Access. But it
    was the closest thing he was familiar with, and the "relationship" holds
    true - at least for MyISAM (which doesn't enforce referential constraints).

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  7. #7

    Default Re: MS-ACCESS Relationships = SQL Views, right ?

    > I'm looking at using NaviCat but I can't seem to find the functionality of 

    Yes. On the MySQL site, there is a (not fully mature yet) tool called
    MySQL Workbench, but I still use its predecessor (see
    http://www.fabforce.net/dbdesigner4/). It takes some time to learn to
    work with it, but than it works OK.

    Best regards.
    --
    Willem Bogaerts

    Application smith
    Kratz B.V.
    http://www.kratz.nl/
    Willem Guest

Similar Threads

  1. access relationships and coldfusion
    By P_Roberts in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 21st, 05:35 PM
  2. MS SQL Relationships
    By ceaseanddesist in forum Dreamweaver AppDev
    Replies: 4
    Last Post: May 10th, 04:33 PM
  3. Help with relationships.
    By tester in forum FileMaker
    Replies: 6
    Last Post: January 8th, 12:44 PM
  4. Replies: 1
    Last Post: September 27th, 01:51 PM
  5. Replies: 4
    Last Post: July 8th, 07:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139