Back to Manual Table of Contents
Here are instructions for creating a very powerful multi-location database setup. This works well for mobile vans that service children or nursing homes. You want all patients in one database, but your network connection may be slow and intermittent, or you might only be able to connect to the network when you return from the field. So instead of the usual single server, you would have multiple servers, one for each mobile van. If you take a laptops to a nursing homes, then each laptop would be a standalone server.
But there are disadvantages if you do not truly have a multi-location setup. If you are just taking your laptop home at night or want access from home, you might consider a different Remote access strategy. First of all, setting up the servers is time consuming and requires expertise that we might not be able to provide. Also, all your primary keys in all your tables will be much longer, making them not user friendly if we need to do troubleshooting. Once you switch to random primary keys which are needed for muliple server merging, you can never go back.
Step one: Setup each individual server and make sure it works properly.
Step two: Setup a replication daisy chain (instructions to follow later). This causes data entered on one server to be duplicated to all the other servers whenever a connection becomes available.
Step three: Enable random primary keys in the Setup | Miscellaneous menu.. This will affect the following tables as well as some more tables added recently:adjustment
appointment
carrier
claim
claimpayment
claimproc
clockevent
commlog
computer
contact
covpat
docattach
document
emailmessage
emailtemplate
employer
insplan
instructor
letter
lettermergefield
lettermerge
medication
medicationpat
patient
patientnote
payment
payplan
paysplit
perioexam
periomeasure
printer
procedurelog
quickpastecat
quickpastenote
recall
referral
rxpat
schoolclass
schoolcourse
screen
screengroup
securitylog
task
tasklist
zipcode
You should designate one server to handle administrative funtions including:
Appointment Views
Autocodes
Claim Form editing
Clearinghouses
Clinics
Counties
Insurance Categories
Definitions
Employees
Fees
Language translation
Security Admin
Procedure Buttons
Procedure Codes
Program Links
Providers
Rx Setup
Schedules, including provider and blockout
Schools