I have the following scenario and wondering if the only solution is two separate fields. I need a field where it sometimes needs to copy the commission amount from another table/field and sometimes I need to enter it manually. I thought of a lookup or auto-calc; however, the I need to create the Closing Notes record at the same time I create the listing record and thus the commission to be oopied is empty at the time of record creation. I can solve this by using a script trigger to relookup at the time I need to enter the closing notes for a sold property; however, this relookups all records and will overwrite any manual entries with the blank field over in the other table.
Question: Is there a way that I can force a lookup on only one record? Or, am I stuck with creating one calc field and one manual entry field?