A few lines about me and Filemaker: I am a doc and a unusual one (as my colleagues would describe me) with an interest in Relational Database. I learnt the basics from the help section of Lotus Approach Database software and one fine moment got to know about the Filemaker and since then there is no looking back.
I am building database for my wife (Diabetes Specialist) The general Structure is Like:
Patient Table: it contains the details of the patients like ID, Address etc
Visit Table: (linked from Patient table by one to many- as each patient has multiple visits). Visit Table has details of the visits like weight, Glucose values for that particular visits and also the treatment given for that visit.
Treatment Table: (Linked to visit Table ) contains a drug and its dose and how to take it.
The scenario is:
since these are diabetic patients most of the treatment will be same for each visit except some minor changes. So What I want to do is: If a patient comes for the second visit If I click a button all the treatmentof the previous visit of that particular patient should be created new under the 2nd visit ( create new records in Treatment Table but linked with 2nd visit)
Can you kindly guide me how to do it.
My attempts so far were
- Find the records of the first visit and duplicate all the found records but the problem is how to link to the second visit.
Your help is highly appreciated.
Thanks and Regards