When a user launches an invoice form, it may be best for both security and performance to create a (local) 'copy' of the invoice table (with only one, new record). This way, the user can cancel/delete the record without impacting the real table on the network. Also, the user's permissions may not allow the user to delete records in the real table - to protect invoices previously created.
Currently, my users have direct access to the table... Question: Is there a standard methodology for the solution described above?