Webster01
04-16-2002, 08:14 AM
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.
Geoff Codd
04-16-2002, 08:20 AM
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
Webster01
04-16-2002, 09:33 AM
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"
Pat Hartman
04-16-2002, 07:27 PM
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.