AnsweredAssumed Answered

Create related record with identical form?

Question asked by jamroman on Mar 3, 2012
Latest reply on Mar 5, 2012 by philmodjunk

Title

Create related record with identical form?

Post

I have two related tables, "Medication" and "Patient".  Each table is related with a "prescription_ID" key. They are related so that new records can be created in "Medication" table as one patient can have multiple meds.  I cannot figure out how to make a script that will reset the entry form and allow creation of new med records while keepiing the patient's name. When I script in the new record form, it erases everything, including the patient name.  I want to keep the patient name, but only erase the current med info for the new record.  

 

Thanks,

 

JR

Outcomes