AnsweredAssumed Answered

Help generating some sort of comparison report

Question asked by TadDaniels on May 22, 2015
Latest reply on May 22, 2015 by philmodjunk


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.