Duplicate data in multiple forms

Webster01

Registered User.
Local time
Today, 20:01
Joined
Mar 25, 2002
Messages
15
I have one form entitled "Patient Demographics". From that form, I have a command button that opens the form "Patient Visit". I would like for the name, address, telephone number from the origninal form ("Patient Demographics"
to automatically populate those fields in the "Patient Visit" form when the second is opened from the first. "Patient Visit" form is based on Patient Visit table, linked by Patient ID.
 
Why would you want to duplicate data, the reason for having relational database is to cut down on unneeded data, The best solution would to have the Patient Visit Table as a subform on the patient Demographics form, this will show the current patient with all the visits for that patint listed in the subform
 
Thank you for your response. The second form "Patient Visit" is used to document aspects of the clinic visit and is then printed for the purpose of hard copy documentation. Because of this, I would like for the demographic data to be displayed on the "visit" form. Duplicate data is not stored in the separate tables for "demographics" and "visit"
 
Use a query that joins to the patient table as the recordsource for the form. That way you can choose whatever fields you need from both tables. Be sure to set the patient demographic fields to Locked=Yes to prevent accidental updates from this form.
 

Users who are viewing this thread

Back
Top Bottom