Automatically assign next value from list

Hi helpful people,

I have a list of voucher codes. When someone fills out a form requesting a code, I’d like to update their record with the first unused code on my list.

I’m stuck on how to update an existing record with a value from another table. Could someone help me with that part, please?