Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2015
    new york

    Unanswered: Ways To designing a database to track Patient

    Hello everybody.
    I am designing a database to track patients over time. They will attend for five visits and have different types of information at each visit.
    I have five subforms to my main form which records the required information. I am controlling which subform appears with a drop-down menu.

    I am having trouble in getting the correct information to show for each visit.
    For example, both Visit 2 and Visit 5 might show the information for Visit 2. This is driving me nuts!

    I've attached a model of the database. Any ideas on how I could remedy this? Thanks!

    Patient Visit
    Thank's a lot!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    there was a very similar post to this a while back. Id suggest you do a search for it.

    the resolution for that was better table design, separate observations from a specific visit (but record what visit the observations were taken).
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Not sure how you attempted to attach your file but it didn't work; it can't be downloaded...and your description doesn't really give us enough information to help you!

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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