Help generating some sort of comparison report
I am brand new to Filemaker. I work in nonprofit clinical research, and trying to organize the data in a simple electronic database.
We see patients and needed sort of a light-EMR type program, so we can track the few tests and images that we create for each patient, based on visit.
I created a table for patient information.
Then I created a table for visit information (linked through patient ID)
I used tabs to sort between the different tests we might do in a standard visit.
What I'd like to do is make another layout/table/or whatever needs to be done to accomplish this, where I can create a sort of "Patient Overview" screen, where there are tabs for each visit for each patient, and then sub-tabs like in the visit screen for each test. That way, we could easily compare results from a single test across multiple visits.
So is there an easy way to do that? Sort of like generating a separate interactive and automatically updating report for comparing the visits.