How to create a new related records without using copy/paste?
I have a simple table that includes a "record number" field. I want to create a new record in another table that includes the "record number" in the current record. but, I don't want to use cut and paste, primarily because I want to retain the contents of the clipboard for future use. I have not found a way to script this, nor have I succeeded using a calculation field. Any suggestions?