A "new" record will contain data identical to an existing record. Your script to open a new window could set a "flag" field to a value and your save button could clear that field so that it is no longer marked as "new". Then your delete record script could check the value of that field before deleting a record.
But you also might also just set up a set of global fields for entering the data for the new record. Then your "save" script creates the new record and transfers the data from the global fields to corresponding data fields in the new record. Then there is no new record to delete when a user "cancels", the script just clears the global fields.
I like the idea of creating global fields but the first field on the layout is a lookup from another table of schools we have contracts with and the second field has logic so it is only entered if the school field is "other" i.e. a school we don't have a contract with. I don't have a clue how to do that with global fields…or if it is even possible.
I'll give the setting a "flag" solution a try first.
Thanks again…you are always so helpful,
It is definitely possible to set up your "lookup" using a global field.