You probably should use a join table here. Patients, Medicine, Dosage ( join ).
The Dosage table can store the foreign key of the Patient, the Medicine, and perhaps the time and dosage amount.
Wow that is the quickest response I have received to any question posted on the internet!
In the "Dosage" table, I would just have _kf_Patient_id, and _kf_Medicine_id and one field named dosage?
When I create the portal on the Patient table, would I choose
"medicine name" from the Medicine table?
"dosage" from the Dosage(join) table?
And finally _kf_Medicine_id from the Dosage(join) table?
Hope this makes sense
And a Huge thanks! mr_vodka
Yes. You can use a popup menu to show your medicines. If you use the option to show the second field as the name and the ID as the first field, when you choose the item in the portal record, it will store the Medicine ID. You can also have the dosage field be a free entry field or you can use another value list... your choice.
BTW, make sure that you turn on allow creation fo records to the dosage table ( on that side of the relationship ) from the patients table occurrence if you want to use the portal to create the related records.
I am truly thankful for your help!
It might not seem like much to you, but you helped me over hurdle, that perplexed this novice.
you are welcome. :smileyhappy: