Simple Relationships Question
Results 1 to 4 of 4

Thread: Simple Relationships Question
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2007
    Location
    NJ, USA
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Simple Relationships Question

    This is probably the dumbest question ever however, after 2 days of searching via the web, I haven't found an answer and I'm probably just doing this wrong. When creating a relationship in my database, if I double click it to view the details, it says its a one to many relationship.

    The problem is, the line that connects the two tables does not have a 1 and ∞ sign on it. It's just a plain black line. Is this a setting or something? Am I doing something wrong?

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Simple Relationships Question

    For a start this is an Excel Forum, not an Access forum.
    Try asking here

    UtterAccess Microsoft Access Help Forums and Wiki
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Aug 2007
    Location
    NJ, USA
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Relationships Question

    Michael,

    Thank you for the link. I actually found out what I was doing wrong. It was different data types (text/autonumber). I don't know how I missed something that trivial but I guess it couldn't have been that trivial to me to begin with. Once I made the data types the same, the relationship updated properly.

    Thank you again for the link and for pointing out that this is an Excel forum. I already know this, which is why I ask my Excel questions in the Excel portion of these forums. If Access related content does not belong in Questions -> Microsoft Access, would you be so kind as to help me to understand what kind of questions do in fact belong here?
    Last edited by reaktorblue; Jun 20th, 2015 at 05:01 AM.

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Simple Relationships Question

    My apologies, there must have been a problem with the thread as I read it in EXcel questions...
    Maybe I shouldn't have had that extra beer after golf....or maybe should have had one more ...!!!
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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