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