We have created a database which creates unique quotes and orders from a relational product database for customers. What we need to do is have the quotes/orders, which are stored as individual records, lockable so their fields cannot be amended in future. However we would like to be able to duplicate the records, but with a new record ID.

Anyone with smart ideas on how any of this could be achieved??

Thanks in advance.

Hopefully, SG

One rather standard practice is to create global fields for data entry, along with a special layout. Once the data is entered, the user hits a button activating a script that creates a new record, moves the info from the global fields to the regular fields, and clears the global fields.

Then make sure all data fields have the "allow entry" button in field format unchecked.

Do a search in the forums: this exact same topic has popped up several times in the last couple of weeks.