Prepopulating an entry with a value from another field
This seems easy, but I cannot find the answer:
I need the user to specify 2 dates: Date of Admission and Date of Discharge
However, after filling in the date of admission, I would like to have the discharge date pre-filled with the value that was entered for the admission date, but then of course be allowed to change the discharged date from this 'default' value.
Is there an easy way to do this?
Open Manage | Database | Fields.
For Date of Discharge, select the Auto-enter by Calculation field option and enter Date of Admission as the calculation.
Leave the "do not replace existing value..." option selected so that this only happens the first time you select/enter a date in Date of Admission.