What relationships have you defined to link your tables and on which table are you basing your report? (What is listed in "Show Records From" in Layout Setup...?)
I have 3 tables - Patients, Assessments and Analgesia. All related by Patient Number, a serial auto-entered number. The report was based on the Analgesia table but used fields from the Patient and the Assessment table as well.
You may have a better solution but I used the script (that fm writes at the end of Report Set up) and added another find to it which limits the report to the records of interest. Works.
Works, does that mean problem solved or is this issue still a problem?
"under the related fields information for all patients is displayed!"
"All related by Patient Number" isn't quite enough detail.
Do you have these relationships?
Sorry for not providing enough info
In making a report, I used fields that would be useful in the report (as one does) but these are from all 3 tables. When I wish to focus on a pain relieving strategy, defined by a group of records in the Analgesia table, I need to include details of what the patient's primary problem is (from the Patient table) and also info about how the patient got on while being assessed (from the Assessment table). I have used New Layout/Report and followed the instructions through to and including the script generation step. While generating a summary report for a specific strategy, I get the layout I need but one that lists all the data for all patients, when related fields are used.
To help, I have added a step at the end of the script to find records within the retrieved data. This has worked and I have limited my records but wonder if I have gone about things a roundabout way.
Yes, you should use some method to specifically find the Analgesea records you want for your report. They will not be selected for you automatically. Performing a find is likely your best option.
My concern about your table structure is that if you base your layout on Analgesia, you will only be able to show data from the first related assessment record. If there is one and only one assessment record for any given patient then this is not an issue. If there could be more than one, the only way to show more assessment records in your report layout would be to use a portal--which isn't the nicest feature to use for a report you might print or save as a PDF. (A separate relationship from analgesia to a new table occurrence of Assessment might be useful for some reports where you want to specify which assessment record you want to see for a given patient.)
I see what you mean. In my reports I have only 2 fields that have multiple values in different records.
With a new occurrence what do I use to relate the tables? Also the tables does it need to be Analgesia----<Assessment ?
If working with more than one table occurrence to the same table is a new idea, see this thread for a fairly simple tutorial that demonstrates the concept: Tutorial: What are Table Occurrences?
After reading and doing that tutorial, you might check out this idea for a way to organize multiple table occurrences in your relationship graph to make it easier to manage the design and function of your system: http://sixfriedrice.com/wp/six-fried-rice-methodology-part-2-anchor-buoy-and-data-structures/
Analgesia----<Assessment (--< means "one to many"), means for any given anlagesia record there could be 1 or more assessment records linked to it. You'll know better than I if that relationship is a good idea or not for your data.
Thanks once again!
A separate relationship from analgesia to a new table occurrence of Assessment might be useful for some reports where you want to specify which assessment record you want to see for a given patient.
I tried this without real success. I cannot figure out how to relate the new occurrence of Assessment to Analgesia. The fields in my report from the assessment table can be sacrificed without real damage. There's always 'Find'
I have been thru the tutorials and kind of understand the idea. My brain cannot extrapolate the sample data given anywhere in Filemaker to patients and operations. It's inexperience.
Now I have to grapple with runtimes. I have just learnt that to make a runtime for windows users (most of my clients) I'll have to bind the database using windows...
I cannot figure out how to relate the new occurrence of Assessment to Analgesia.
That truly is the key question. Here's the classic way to do this, but think it over before you try this. It makes assumptions that may not be true for you data structure:
Define a serial ID number in Analgesia, AnalgesiaID. To link a given assessment record to that one Analgesia record, define a matching AnaglgesiaID field in the Assessment table and link the two fields in a relationship. A portal to Assessments can even be set up on an analgesia based layout to log a series of assessment records for a given Analgesia record--which saves the user the trouble of entering the analgesiaID number from the current Analgesia record in to the matching field of the new Assessment record as this value can then be entered automatically.