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.