Random Default Value Combo Box Selection

[sking89]

Hi. I have a database that keeps track of our consulting projects. I have one field that has the consultant who is assigned to the project (values linked to a different table.) Is there anyway to set the default value to randomly select one of the values from the combo box when I create a new record?

Thank you so much for your time!

[orange]

Why would the assignment be random? Just curious.

[sking89]

Randomly assign projects to consultants