Results 1 to 2 of 2
  1. #1
    Newbie2 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Location
    Melbourne Australia
    Posts
    3

    Pull value from one field to a specific record

    Hello and thanks in advance for any hints, tips or advice.



    Surely there must be someone out there that can help me with the following problem. Without going into all of the filed in my tables the following pertain to my (simple?) request.

    Table 1 Patient Registration
    Patient ID (Prime Key)
    Surname
    First
    DOB ....

    Table 2- Clinical Out Come Data
    Outcome ID (Prime Key)

    Patient ID (as a foreign key)
    Surname
    Date of appointment
    Results....


    Here’s what i would like to do.
    After data is entered into the Patient Registrant form I would like the Surname to automatically appear in the Surname field on the related record in next table (Table2). I know data should not be duplicated like this, but for efficiency and accuracy the user needs to physically see the name of the patient on every form as they are entering the data... retyping or cut and pasting is a real pain.


    Hope someone can help
    Newbie2s

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    You already know that duplication of data in tables is not advisable & particularly in this case there is no need.

    If you can, definitely try to avoid what is being asked for?

    If still you need to do it, perhaps,
    just think along lines of
    using a query ( which uses the 2 tables )
    including all the fields from the Outcome Table & the surname field from the Patients table, in the query result,
    as the source for the sub-form (keep the surname field in the sub-form as read only).

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-22-2012, 02:36 AM
  2. Replies: 5
    Last Post: 12-22-2011, 11:01 AM
  3. Random Record pull
    By Madmax in forum Access
    Replies: 2
    Last Post: 06-28-2011, 08:26 PM
  4. cannot pull the correct record
    By simba in forum Reports
    Replies: 1
    Last Post: 11-30-2010, 10:45 AM
  5. Code to pull in data from a specific record
    By jdunn36 in forum Access
    Replies: 1
    Last Post: 09-20-2010, 11:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums