I currently have a database consisting of one primary table with about 30 fields per record. My ultimate goal is to take each record that reflects a medical study and show each staff member participating on that study, the percentage they contribute, and their role. There are usually about 5 staff members contributing to a study. As of now, I am using a subform to gather information but this is not sufficient for several reasons including:
1.) Redundant data entries
2.) Margin for error in data entries
3.) Results of subform being shown in a pivot table which is not highly user friendly and requires administrator instruction
What I would like to do is use combo boxes to identify the staff names and their roles and incrementing/decrementing list box to identify their percent effort as opposed to the subform collection currently in place. Does anyone have any suggestions as to how I can add these several different files into one record? BTW, I have one unique field that is an autonumber field to work with. The rest are not required and can be the same for frustrating reasons.
Please help!
L
1.) Redundant data entries
2.) Margin for error in data entries
3.) Results of subform being shown in a pivot table which is not highly user friendly and requires administrator instruction
What I would like to do is use combo boxes to identify the staff names and their roles and incrementing/decrementing list box to identify their percent effort as opposed to the subform collection currently in place. Does anyone have any suggestions as to how I can add these several different files into one record? BTW, I have one unique field that is an autonumber field to work with. The rest are not required and can be the same for frustrating reasons.
Please help!
L
