Abstract: In accordance with the principles of the present invention, an electronic medical record system is provided. A clinical web server connects to at least two information technology systems and providing real time exchange of data between existing databases. The clinical web server translates and maps existing databases into a common data structure format. A message to be transmitted is generated. Routing type and formatting routing are determined based on recipient delivery requirements. The message is parsed into segments and fields. The appropriate party to whom the message is directed is determined. Identifiers in the message are translated from a sender's value to a recipient's value. The message is translated from a sender's format to a recipient's format.