User Profile

Collapse

Profile Sidebar

Collapse
Gem
Gem
Last Activity: Sep 4 '21, 06:26 AM
Joined: Jan 31 '07
Location: Perth, Australia
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Gem
    replied to Query returns too many records
    in Access
    Hi NeoPa
    I'm guilty of not paying attention..... thank you for replying.

    Here's what I have now

    Primary Table
    tblPatient
    Record autoNo.
    pkPtFileNumber (indexed No duplicates)

    Second Table
    tblOperation
    pkOperationID autoNo. (indexed No duplicates)
    fkPtFileNumer (indexed Duplicates OK)

    Third Table
    tblTargetsites
    pkTargetSiteID...
    See more | Go to post

      Leave a comment:

    • Gem
      replied to Query returns too many records
      in Access
      Hi Guys
      It's late and I'm going to ask a really dumb question - Now that I have my Join table how do I populate the thing with the exisitng records? I have 164 records in tblOperation and 463 in tblTargetsites

      I tried using an append query based on tblOperation and tblTargetsites but just ended up duplicating the original problem ie. too many records - so that was not good.

      Also, how do I ensure that all rew...
      See more | Go to post

        Leave a comment:

      • Gem
        replied to Query returns too many records
        in Access
        OK, yes I see, you are both saying the same thing - the tblOperation and tbleTarget is in fact one-to-many (one operation can have many targets). In tblOperation and tblTargesite I had put the default record number as the primary key and in tblpatient the pk is pkPatientFile number. I see where I went wrong. I will put in the join table.

        thanks a million
        Gem
        See more | Go to post

          Leave a comment:

        • Gem
          started a topic Query returns too many records
          in Access

          Query returns too many records

          Hi
          I'm struggling with a query returning too many records.

          I have 3 related tables.
          tblPatients
          tblOperations
          tblTargets

          Each patient in tblPatients can have more than one operation (one-many)
          Each Operation in tblOperations can have many targets (many-many)

          The unique key across tables is PtFileNumber

          So one patients data would look something like this...
          See more | Go to post
          Last edited by NeoPa; Feb 11 '07, 08:41 PM. Reason: Tags for Layout
          • Gem
            replied to ChkBoxes on a Form - tick one or more before continuing
            in Access
            Thanks guys
            I learnt something today - I had thought that the "AND" operator would not work, But that's becasue I didn't quite understand how the 'AND' operator works when 3 expressions are involved - You forced me to try again and voila embarrassingly simple!

            Also - the point about the msgbox being incomplete - true, because I want to try a few things first then get back to the forum if I run into trouble.
            ...
            See more | Go to post

              Leave a comment:

            • Gem
              started a topic ChkBoxes on a Form - tick one or more before continuing
              in Access

              ChkBoxes on a Form - tick one or more before continuing

              Hi There,
              I'm new to the fourm although I have used it lots of times looking for answers in the past and it's been great. Can someone give me a nudge in the right direction with this niggley naggley problem?

              I have 3 chkboxes on the bottom of a form. It is essential that the user does not miss checking at least one box before clicking a button to move to the next form. So I included this code to the button to force a msgbox...
              See more | Go to post
              No activity results to display
              Show More
              Working...