AnsweredAssumed Answered

Auto-populate fields in new record with data from previous record

Question asked by BenPlunkett on Jul 20, 2011
Latest reply on Jul 20, 2011 by philmodjunk

Title

Auto-populate fields in new record with data from previous record

Post

Hello,

I'm just beginnig to work with FileMaker, so please bear with me.

I'm working on a database which will track patients and the medications they are taking. When a physician sees a patient in clinic, they will create a record in the database with a list of all the medications they are taking, and the doses. When a patient comes in for a subsequent visit and their medications change, the physician will create a new record with the current list of medications (rather than editing a single record for each patient, to allow the physician to see the patient's medication history).

Is there a way for subsequent medication records created for the patient to be automatically populated with the data from the previous record? If a patient is taking 6 medications, and on the second visit they only change a single one, it would be easier to create a record that's a copy of the previous record and make the change, rather than re-creating the full list of medications from scratch.

Outcomes