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!