Help with database

The unique number is generating but I want it to either generate the counter in the primary field or copy the number once it’s generated, over to the primary field.