I am trying to create a sub summary of certain data in my database. I have one table that lists patient IDs, and this parent table is linked with multiple child tables through this field. I would like to generate summaries of the number of patients who have certain qualities as specified in some of the child tables, such as a certain condition. I'd like to generate a list of such patients. While in patient list layout mode, I went to "insert" then "part" then sub-summary" and then specified a specific field from a specific table. However, nothing shows up after having done this. Can anyone please tell me why?

I don't think we have enough details to answer your question.

Speaking generally, I see one possible issue with your schema: what if a patient, based on "certain qualities as specified in some of the child tables", falls in more than one category?

sorry for the late response. that should be ok if a patient falls into more than one category, and this will probably happen a lot. I want to create summaries based on those individual categories, such as creating a list of all patients in the database that have a particular disorder.

am i able to make a summary for the following?

-make a list of all patients whose records have a certain checker box marked for a value set in a specific field

Ex. Generate a list of all patients who are diagnosed with temporal lobe epilepsy, or all records that have a checker box marked for temporal lobe epilepsy in the "epilepsy type" field.

thank you very much for your help!

am i able to make a summary for the following?

-make a list of all patients whose records have a certain checker box marked for a value set in a specific field

A list is not exactly the same thing as a summary.

You can produce a list of patients with one particular disorder - simply by finding them. You cannot produce a list like this:

Disorder Alpha:

• Patient Adam

• Patient Betty

• Patient Cecil

Disorder Bravo:

• Patient Betty

• Patient David

• Patient Eve

unless you have another table joining patients to disorders (where patient Betty would have 2 related records)..

I have a table with patient names, and a table with disorders. Then i created a table occurrence to join patients to disorders.

Can you explain how to make the list like the one above?

Thanks again for your help!

You cannot make a list like the one above without adding a third table (not another occurrence of your existing tables). In this table there would be a record for each patient/disorder association. See an example here:

http://fmforums.com/forum/showpost.php?post/309136/