Hi there,
(i have only mild knowledge of programming, but have used Access before, so please excuse me if my question might be noobish)
I was given the task to perform a Systematic Review on a medical subject. 2 or more physicians will be evaluating over 400 studies and extract pre-defined data from those published studies.
Hence, Each study will be evaluated at least twice and the data also will be extracted twice for each study.
After that an Independent Researcher will integrate "both" datasets and decide if the study is valid and the extracted data will be used.
So far i have made several tables for the extracted data, an overview table and an Evaluation table.
My Problem is, that if more users will evaluate the same study i will have multiple unique IDs for the same study. Is there any way of feasibly indexing or designing the tables for this project?
thank you all so much in advance