A community electronic medical record provides access to a patient's records. A unity server of the present invention allows a user to enter a query requesting the information that a medical provider needs such as past history, allergies, billing information, and other medical data that may be related to the patient. The unity server queries at least one database, preferably many, to access the patient's records relevant to the provider's query. The unity server retrieves information from multiple sources to provide increased information for treatment of the patient.