duplicate records - duplicating serial but serial increasing????
Ok I have taken the inventory template db and used it to come up with my own inventory DB for software licensing. My question is in regards to the duplicate record option. When using this it would also duplicate the Inventory ID which should be a unique value. I have gone in and modified this so it does validation and will not allow duplicates. But....
If a user clicks this button even though they can't save the record and actually create it. The serial count gets increased by one.
Is there anyway to make duplicate record not duplicate this field but all the rest?