I am trying to make a database which has 7 different databases that are all linked by a common value, Medical Record Number. I am trying to use the database in a way in which if I start a record on Database 1 and entere a MRN number, it will create a medical record number in the other 6 databases. By doing this it will ensure that the user is entering data for just that individual under that particular MRN number in all the databases.
Is this possible, and if so, how do I go about doing this? Right now I have to create a new record in each database everytime I want to enter data and I also have to re-enter the MRN number. Ideally I would like to have to enter the MRN number just once and it will be tehre on the subsequent databases.
Thanks in advance for your help.