Create and print variable number of field sets
I'm not sure how to search this so I'm just going to ask. Sorry if it has been answered before. We use FM 8.5 in our medical practice to create procedure forms. We are trying to design a form with patient history, medical problems and medications. For each patient, we must list the medication name, route of administration, and dose. Obviously, each patient will have a different number of medications. We'd like to have the form look something like a mail merge program where empty fields are not printed and the layout is adjusted accordingly. Two different sheets would print out something like this
Smith, John Doe, Jane
Med 1 Med 1
Med 2 Med 2
Procedure Med 4
Should I just create fields as we normally do and then for medications create med1, route1, dose1, med2, route2, dose2......med30, route30, dose30? The information below could be set to slide up when the medications are blank (like where I have Procedure written). I'll have to experiment a little, but any guidance would be appreciated.