A bit of background...



I am designing a master database for the assisted living home I work at. I need to include various information about our residents and their medical information for quick access by the staff.

I have done a pretty good job of entering in data and creating forms to help fill in the blanks, but I am trying to make a form that will show certain data from several tables together.

I have 5 tables: Resident Information, Physician Information, Pharmacy Information, Resident Doctors and Resident Pharmacies.

The Resident Information table is associated with a Query of the same name.

I have a Form drawn up for entering in information that links to all of the tables. I am using the Apartment #s as the primary key, except for the Physician and Pharmacy information. The Physician Information and Pharmacy Information tables use an auto number but only list the information associated with each. The Resident Doctor and Pharmacy tables have the Apt # with the Last Name of the Doctor or Pharmacy Name listed.

In the form, it is intelligent enough to have a drop down list of either doctors or pharmacies. In Design and Format views, if you click on a doctor or pharmacy in the drop down list the contact information automatically fills in the fields below. However, when I click on form view, the entire Detail part of the form completely disappears. Also, this form tends to repeat the detail form with every record when I print it.

How would it be possible to get this thing to show the fields in form view AND print only one record? Also, if it would be possible to export this into a pre-formatted Word document how would I be able to do that? If I need to I can upload the basic file to view.

Thank you so much!