NewtoFileMaker88 Posted October 20, 2011 Posted October 20, 2011 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?
comment Posted October 20, 2011 Posted October 20, 2011 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?
NewtoFileMaker88 Posted November 10, 2011 Author Posted November 10, 2011 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!
comment Posted November 10, 2011 Posted November 10, 2011 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)..
NewtoFileMaker88 Posted November 10, 2011 Author Posted November 10, 2011 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!
comment Posted November 10, 2011 Posted November 10, 2011 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/
Recommended Posts
This topic is 4779 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now