genrating new ord no in table

[John thomas]

how do i get form to generate a new ord ID for the same customer in my orders table

 

[Sketchin]

Create a "Duplicate record" command button?

 

[John thomas]

many thanks for that, so simple when you know how