Results 1 to 5 of 5

Thread: One to One

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I am having a spot of bother returning records in a query with a one to one relation. Table A's Pk is the FK in Table B with FK duplicates set to no. I have say 10 records in table A and 3 in B. In my query the join has been set to shop all records in A but the query is returning "no records found". I am puzzled to say the least?


    Thanks, Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd have to see a stripped down and zipped copy of the database.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans, it is attached, do please excuse the naming conventions and the modelling, it is inherited. There is a one to one relation with trsmain1 and tranSTD1. When I select show all in trsmain1 in the query qmain it returns a message saying no records found yet there are clearly records in trsmain1 and some in the other table too. I am at a loss.
    The password is Transfer

    Many thanks, Darren.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It's because you have made qMain a totals query. If you make it a normal select query by toggling View | Totals off, you can set the join the way you want.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Cheers Hans, i feel so foolish!

Posting Permissions

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