checked boxes to filling in data

[peter2424]

i'm new at filemaker and computer programing, so any help would be appreciated.

i'm in the medical field and want to keep a close attention to my patients' medication lists. i am creating a large (ie., more common) drug list of all my patients' medications; i am going to create it as a value list and field format it as a check box (so i can check off meds for each patient). that's the easy part. now, as most of you know, we take medications every so often (every 8, 12, 24 hours). so i as i check off a medication, i would like filemaker to ask, "how much", and "how often" for each medication. i would assume a computation would be the best solution (if, 'checked box', 'ask amount'; i don't know the computer language answer). or should i do a scripmaker step? i'm new at computer programing, so please reply with easy terminology. thanks, peter

[Fenton]

This is a classic "you need a related file" situation. Checkboxes stop being useful at a certain point.

Create another file, "Patient_Medications."

Fields:

PatientID, Medication, Amount, Interval

I just built a little file. It's easier than explaining. You would use your existing medications file as the value list for the choices. I just used the field.

Patient Meds.zip

[peter2424]

hi fenton,

thanks alot for the example. it helped me understand the relational database part. i might ask you another question as i create my database program at a later date.

thanks, again,

pete

[peter2424]

fenton,

when i was going through one of the files, patientss, how can i add more 'medications' to the list? right now, the list includes: beer, coffee and tea. i could not find the med list to edit this. i went to the define value lists (under file), and value list name 'meds' had the source 'from another file' called "meds". where is that list?

thanks for your help, pete

[-Queue-]

The value list exists in the related file, Patient_Meds. Go to your Window menu and select Patient_Meds from the list.

[peter2424]

queue,

i did. when i went to patient_meds file and looked under the defined value lists, the source of the value list name "meds" is from field; medication lists is from the patient_med file. i could not get into the medication list to edit it. do you know how? i want to know how i can add another medication, let's say wine. thanks.

[-Queue-]

If it's a value list based on a field, then add a new record with a different medication (say wine), and you'll have created an additional value list entry.

[peter2424]

thanks a bunch!! it worked. it's so frustrating until something finally works.

thanks for your help, pete

[peter2424]

hi queue,

i'm stuck again. i'm using your example you gave me. now, i'm trying to list all the fields on one line, separated by a comma, in another (newly created) field. for example, if the meds (in your example, coffee, tea, beer) are given every 8 hours (interval hours), then i want list all meds in a new field called "8 hours meds".

i wrote a script:

Loop

If ["Patient_Meds__PatientID::Interval_Hours = "8""

Insert Calculated Result ["8 hours meds","Patient_Meds__PatientID::Medication & Patient_Meds__PatientID::Amount & Patient_Meds__PatientID::AmountLabel & Patient_Meds__PatientID::Interval_Hours"]

Insert Text [", "]

Go to Portal Row [Exit after last, Next]

End If

Exit Loop If ["Patient_Meds__PatientID::Interval_Hours <> 8"]

End Loop

this script does not seem to go to the next portal row to obtain the next medicaton (tea) and list it if the interval is 8 hours.

i also tried to create a calculated field:

Patient_Meds__PatientID::Medication & Patient_Meds__PatientID::Amount & Patient_Meds__PatientID::AmountLabel & Patient_Meds__PatientID::Interval_Hours

and then "checked" the repeating fields with a maximum of 20 values. this did not work either.

can you help me out?

thanks,

pete

[Ugo DI LUCA]

Hi,

You want related lists of Med depending on an interval ?

And you want this list to appear in a field, separated by a comma ?

It's not clear how many fields you'd have, which seems to depend on the number of different intervals. I also assume that is why you were looking for repeating fields.

The comma thing would be easy, by only substituting the "

[peter2424]

ugo,

i was using example files that 'queue' sent me awhile ago. in reality, i'm creating a medication database and want to organize each patients' (all) medications by organ system. for example, cardiac (heart pills), infectious disease (antibiotics), pulmonary (like asthma drugs).

i have created two files (based on queue's example). patient history and patient medication; related based on their registration number.

the fields are: medication name, amount, dosage (units), interval, and organ system. (a new field would be called 'medication_cardiac.) i created a portal record of 10 rows (for 10 medications). when i wrote the script, the script inserted the first drug that had cardiac as the organ system, but would not go to the next row. that's where i'm stuck.

your suggestion: valuelistitems. is that created under define fields, or define value lists?

i understand the Substitute(field, "