Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2002
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Tables/Forms

    I'm using Access 97 and have created two main tables. The first is the patient demographic data, the second is their appointment(s) information/results. The problem is that there under the appointment information there could be procedure(s) that could have taken place. I've tried two thing: First I tried splitting up the appointment(s) table and took the procedure information out. Then created a query to link the patient demographic data and the appointment(s)data. Then took that query and linked the procedure table. But when I tried to enter data, it says the recordset is not updateable.

    The second thing I tried was, keeping just the two tables, I linked them in a query and in my form (I've been using tab controls), I created a subform (using tab controls) and brought in the procedure data. My problem doing this is that since there can be multiple appointment dates, the subform is not picking up the current date. Is there a way I can set a tab control within a tab control page.

    I don't know vb, so any suggestions without using it would be greatly appreciated.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Linking Tables/Forms

    I'm not sure I follow what you are trying to do, but I'll take a shot at it. It seems to me that you need a 3rd table for procedures, which are specific to an appointment. So, your relationships would be:
    Patient ==> Appointments (1-to-many)
    Appointments ==> Procedures (1-to-many)

    You can't put a tab within a tab. However, a tab page can contain a subform, and the subform can have a tab control on it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    Jul 2002
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Tables/Forms

    Thank you, I tried it and it worked. <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

Posting Permissions

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