G
Guest
Hi
I have a table named History and table named Medications. The key in
History is EncounterID and there is a memo field in History named MedList.
The key in Medications is MedicationID and there is a one to many
relationship between History and Medications tables as one EncounterID can
have multiple MedicationIDs. I have a HistoryForm in which there is a
MedicationSubform.
I would like to write a code so that when the user fills in all the records
in the MedicationSubform and moves onto a different subform, the MedicationID
control data is added to the Medlist memo field in a list format. Preferable
numbered but if that is not possible just as long as they are in a list one
under the other.
I am trying to do this because I would like to merge the History table
fields onto a Word letter document and have a section named medications that
I want all the MedicationIDs listed. I couldn't figure out how to make the
Word document look up multiple records for a single document so I thought I
get around it this way.
I would truly appreciate help is solving this problem in any way.
Thank you,
I have a table named History and table named Medications. The key in
History is EncounterID and there is a memo field in History named MedList.
The key in Medications is MedicationID and there is a one to many
relationship between History and Medications tables as one EncounterID can
have multiple MedicationIDs. I have a HistoryForm in which there is a
MedicationSubform.
I would like to write a code so that when the user fills in all the records
in the MedicationSubform and moves onto a different subform, the MedicationID
control data is added to the Medlist memo field in a list format. Preferable
numbered but if that is not possible just as long as they are in a list one
under the other.
I am trying to do this because I would like to merge the History table
fields onto a Word letter document and have a section named medications that
I want all the MedicationIDs listed. I couldn't figure out how to make the
Word document look up multiple records for a single document so I thought I
get around it this way.
I would truly appreciate help is solving this problem in any way.
Thank you,