Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Location
    Virginia, USA
    Posts
    98

    Question Unanswered: Relationships In Access

    I'm building a database in Access and working out the relationships now. My problem is that each time I make a relationship it comes up one to many. I need a few one to ones and was wondering how I can get it to do this.

    Thanks.

    KC

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    If you index both of the fields and dont allow duplicates then you can obtain a 1 to 1 relationship,

    THe index property can be set in the table design choose
    Indexed(no duplicates)

    Dave

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    In general, you should never have a one to one. If you have a situation where you do, then you probably don't need two tables. All of the information should be in the same table. To be sure, you should post more information about what kind of data is in the two tables.

  4. #4
    Join Date
    Sep 2004
    Location
    Virginia, USA
    Posts
    98
    Thanks to you both. This helps.

    KC

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DCKunkle
    In general, you should never have a one to one. If you have a situation where you do, then you probably don't need two tables. All of the information should be in the same table. To be sure, you should post more information about what kind of data is in the two tables.
    Not quite true ... I had at one time that exact thing ... It is useful to break up related info that would exceed 255 columns (max Access # columns for a table) into more than 1 1-to-1 related tables ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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