i don't know if the simplicity of the subject heading really does the thread i'm introducing any justice....
i have a database with a host of interrelated tables. at the simplest level, we have a patient registration table which has a medical record (MR) number. other tables may follow the patient over time or record previous or concurrent medications and so on and so forth, but in every table is the ubiquitous MR number.
for reasons that might not have anything to do with this, what we're aiming to do is somehow create an a2k mdb file with a subset of the data found in the 'native' tables, minus the confidential properties of the patients.
at first it seemed as if creating a blank database and linking every table in the parent to it was the approach to follow, however it occurs that this one would bring with it the MR numbers (unless it doesn't which would probably help a bit).
having never replicated a database, it occurred to me that perhaps that approach would be worth pursuing if it would result in subsets of data that denied the observer info about the MR.
perhaps there are other approaches..
has anybody met this problem?
“The philosophy of the school room in one generation will be the philosophy of government in the next." --- Abraham Lincoln
i have a database with a host of interrelated tables. at the simplest level, we have a patient registration table which has a medical record (MR) number. other tables may follow the patient over time or record previous or concurrent medications and so on and so forth, but in every table is the ubiquitous MR number.
for reasons that might not have anything to do with this, what we're aiming to do is somehow create an a2k mdb file with a subset of the data found in the 'native' tables, minus the confidential properties of the patients.
at first it seemed as if creating a blank database and linking every table in the parent to it was the approach to follow, however it occurs that this one would bring with it the MR numbers (unless it doesn't which would probably help a bit).
having never replicated a database, it occurred to me that perhaps that approach would be worth pursuing if it would result in subsets of data that denied the observer info about the MR.
perhaps there are other approaches..
has anybody met this problem?
“The philosophy of the school room in one generation will be the philosophy of government in the next." --- Abraham Lincoln