Scripting a complex find and sort

[Mad Russian]

I have a (Client) file in which I record basic information about therapy clients. In a related file (Reports), I have multiple fields that record outcomes and over time the status of each outcome for each client.

The (Reports) file can store outcomes in Initial Reports and at later dates in multiple Progress Reports and finally in a Discharge Report. In each report after the Initial Report, I want to retrieve all previous outcomes for the client and update the status of each outcome plus add new outcomes.

My thought is to establish a relationship from Client to Reports based on CLIENT ID concatenated with REPORT NUMBER. REPORT NUMBER will increase from 1 for each new report for that client.

My question is how do I retrieve all current and previous outcomes for the client in the current report?

I had thought to script a find in the related file (Reports) that retrieved all outcomes in this file in a subsummary layout sorted by REPORT NUMBER. The body part of the layout would contain other client information that does not change over the treatment course for this client.

Any suggestions or guidance would be greatly appreciated.

Figurski

[IdealData]

Your "key" field is the key here (sorry !).

You've already realised that you can concatenate a primary and secondary content to provide a sub-group of related records.

You can also maintain multiple line entries in the "key" and FMP will see all of them as valid key entries, viz.,

contents of "key" field

CLIENT001

CLIENT001REPORT001

Now you can GTRR for either of the "keys" in the key field - thus you can get ALL your CLIENT001 records together, or just a specific report subset.

There is a limitation that ONLY the first 20 chars of an FMP key field are indexed, so make sure your key entries don't exceed this on any line.

This also works for MANY TO MANY relationships where the key fields in both files can have multiple keys and FMP will match them ALL.

You need some solid script routines to maintain the "keys".

Mind blowing !