Hi
I'm new on this forum. I've spent the last couple of days searching for a way to do this but to no avail.
I have a form that lists customer details. If those details change we keep an old copy and use their existing customer number on a new record (Primary key is Date of Registration...