/EDIT: I'm medic practitioner and this is a feature I need to add to my existing base I work with, but a) there are datas of my real patients b) it's in polish language, so I build this "example base" to catch the mechanism.
/EDIT2: Now the base is attached to the post
Hi there!
I have some specific problem and im looking for solvation quite a while, unfortunately I dont know VBA, but maybe it's possible to solve it without coding?
So I have 3 tables:
1. MedicationsList (just simple list)
2. PatiensList (as above)
and my destination table:
3. MedicationsSchedule, containing: Person, TypeOfDrug (taken as combolist from above tables), Dosage (I fill it manually), DateOfDosage (the date when the patient should take/inject the medication).
My problem is, my patients take few drugs in the same time, but in different time intervals and adding the records manually is time consuming, so I imagined the form (frmMedicationSchedule), where I can choose patient, drug, dosage (it would be perfect if those fields can be prefilled with fields from last record of the table, which I tried unsuccessfully manipulating with Defaults and Fetch Defaults), but in addition to that - form should allow me to fill DateOfFirstDosage, then number of dosages (how many times patients should take the drug) and intervals in days (how often should patients take the drug). Example - I fill the form with: Person: Mr 1, TypeOfdrug: Drug 1, Dosage: 2 tablets, DateOfFirstDosage: 01.08.2018, Number of dosages: 4 and Interval (in days):3, and after some kind of macro connected to clicking button (I suppose), it would add 4 records to the table with different dates (01.08, 04.08, 07.08, 10.08).
I tried to do the default values in new record, which would significantly speed up my work, but can't do working defaults with last record values.
Anyone knows how to do something like that? I attach screenshot of all tables, relations and form
and if you want to see the base itself - it's attached.
Thanks in advance!
Lukasz