0 Replies Latest reply on Jul 28, 2011 6:55 PM by MatthewDetzel

    beginner help with tables

    MatthewDetzel

      Title

      beginner help with tables

      Post

      Hello,

      I wish to build a file that lists what nurse works for a particular doctor, and what facility they work at.  A doctor can work at multiple facilities, and a nurse can work for multiple doctors but only one facility.  It would be super great if I could pull up a facility, and have it list which nurse works at that facility and for which doctors, or pull up the doctor and list what nurse works for that doctor and what facilities they work at, or pull up the nurse and list what facility and doctors they can work for at that facility.

      I have no clue where to begin!

      TIA

      edit: Maybe this would help someone help me.  The list I currently have (edited, of course!):

      • Dr. A 
        • Facility 1
          • Nurse Jane
          • Nurse Cindy
          • Nurse Mary
        • Facility 2
          • Nurse Tyrone
          • Nurse Katrina
          • Nurse Andy
        • Facility 3
          • Nurse Fred
          • Nurse Tupak
          • Nurse Shelley
      • Dr. B  
        • Facility 2
          • Nurse Tyrone
          • Nurse Andy
        • Facility 3
          • Nurse Tyrone
          • Nurse Katrina
          • Nurse Andy
          • Nurse Bobbie
          • Nurse Felicity
        • Facility 5
          • Nurse Johnny
          • Nurse Cheryl
      • Dr. C   
        • Facility 1
          • Nurse Jane
          • Nurse Mary
        • Facility 6
          • Nurse Gizelle
          • Nurse Poppy
          • Nurse Frank
          • Nurse Guiseppe
          • Nurse Henrietta