keywords needed to populate db

[letsomebodyknow]

I need to populate my test db with data.

I do have recourds of fname, lname ect from other tabels and/or excel files.

However, I do not have a needed field which is part of the table needed for the test db.

This field has five different possible entries.

My solution would be populate the table and then create a new field.

Then populate that field........ This is where I need help. How do I randomaly enter the field with the 5 possible until all recourds have retained a value for the new field.

Thanks
Tom