connect tables and make a search in all of them, then show data in form

trolleri

New member
Local time
Today, 04:05
Joined
Jan 23, 2013
Messages
7
My first database is going to be made for a clinical trial. The patients fill out lots of different questionaries, and there will be lots of blood samples, and measurements of different kinds. Every patient are being followed for half a year, and the different information needs to be recorded into the database at different times.

It has been requested that all data is visible from one form only, with the following structure:

To the left there will be an area with identification of the patient, inclusion number, and static values like "gender" and "birthdate" etc. This area need to have a search function on the inclusion number -field, so it will be possible to find patients already in the records, and continue recording on them if they already exist.

To the right there will be different panes with both checkboxes, dropdowns, textfields etc. for filling out the collected data on a patient. It is crucial that these panes are all connected to the identification-area, so data from one patient stays connected to the excact same patient. Remember the different data-samples from one patient gets collected at different times of the year.

The formular is going to be crazy big, and needs to be handled with the least confusion. When the trial ends, all data will be exported to tabels for statistics - SPSS program.

I have already tried to make the database in a single table only, but there is simply too many fields for Access to allow it. Then I created several tables.

How do I make the identification-area with a search-button?

Thanks in advance

P.S. Does anybody have experience with Access User-Level Security on a database similar to this one? I read security isn't great, but it might help restricting the damage one could do if not computer-engineer (nurses etc.).
 
Last edited:

Users who are viewing this thread

Back
Top Bottom