Help: Save, Duplicate Record cum auto del specific field for user to input record

[Crystallew]

Hi (",o)

Doc No.: FIELD 1 (Step 1)
Date: FIELD 2 (Step 2)
Team No.: FIELD 3 (Step 3)
Badge No.: FIELD 4 (Step 4)

SAVE Command button (Step 5)
DUPLICATE RECORD Command button (Step 6)

Currently User1 is required to follow step 1 to 5 to input field 1 to 4, then User2 will continue with step 6 and go to erase step 4 field and input his/her value then click save in step 5.

Can step 5 & 6 be combine as 1 command button and at the same time on the duplicate record {field 1-3 remain but field 4} is auto deleted for another user to input value?

Can anyone help? Your help is greatly appreciated..

 

[Guus2005]

You should use a table definition to prevent duplicate records. Extend your key to more fields. This way a duplicate record is out of the question. You can skip button 6.

Ths question title doesn't make any sense to me.