I have a database of studies and their principal investigators (and much more information). I also have 3 tables linked to each study by a protocol number that is unique to that study. I would like to be able to generate a report by principal investigator. So, for instance, I want to have the same type of report with the same fields, but just limited to that principal investigator. is there a way to do this without writing a script for each PI (there are over 20 and new ones get added all the time). Can I create a button that will allow me to specify the principal investigator and then create the report?
thanks so much