Thank you in advance for your advice. I am not new to filemaker but am designing a more complex database than the simpler ones I have created previously.
Essentially I am developing a database to look at follow up of patients who have undergone surgery for weight loss using data from a large online national database. The format is not what I require and the solution is beyond my limited filemaker skills!
Follow up data comes in the following format:
There is a separate linked data table with preop data including date of operation, weight before surgery and type of surgery etc.
What I wish to create is a data table with the above follow up data arranged as follows:
|Patient ID||1st FU Months||1st FU Weight||2nd FU Months||2nd FU Weight||etc...|
And then a second table categorised as follows:
|Patient ID||<3 month FU weight||3-6 month FU weight||6-12 month FU weight||etc...|
I would be very grateful to the filemaker community for any advice!
Research "cross tab reports" here in the community forum. There are several different ways to produce the results that you need here. Filtered portals and summary fields are probably the simplest to set up, but also can have performance issues if you are working with a lot of records. Other methods using relationships or ExecuteSQL may also be used.