help!!

[ref1031]

I am making a database for a clinical research study, in which there will be several subjects coming in for visits (about 11 visits each?) and for each visit there are several forms that are filled out, such as neuropsych forms, vitals, EKG report forms, etc. I have all of the forms that I need created already, yet some forms are not used for all of the visits.

Would it be possible for me to create a "Subjects" page, in which all of the subjects are listed, with IDs, DOB's, etc, and somehow I could create a script or something that will bring me to all of the visits (V1-V11) for only one specific subject at a time?

Many thanks, and sorry that this is probably extremely confusing!!!

[cpe1704tks]

ref1031,

I created 2 tables. Number 1 is the subjects and Number 2 is the visits. Then in the relationships tab i created the relationship beteween the tables using the subject id in the subject field and connected it to the foreign key subject id in the visits field. Then I created a portal in the subject layout that uses the relationship showing the date, visit and notes(you can put any field from the visit table you want). In the visits layout, there is a pop-up menu, that gets its values from the subject layout(First and Last Name).

Take a good look at the relationship, how the portal shows its information and how the patient value list in the visit table is populated from the subjects table. The rest of the information in the file is straight forward.

subjects.zip

[ref1031]

thank you I appreciate it, and it really helps!! but is there a way that I would be able to access different forms for data entry from each visit? for example, visit one contains such clinical forms as vitals, ekg, consent forms, etc.? I am not sure if this would be possible.