AnsweredAssumed Answered

Create related record with identical form?

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


Create related record with identical form?


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.