Random field value from another table

[expublish]

Database structure:

tblusers(ID,username,password)
tblvalues(ID,value)

They are not currently joined in any kind of relationship.

When I add records to the tblusers table I would like the password field to automatically be populated by a random value from the tblvalues table.

There are lots of records in the tblvalues table. The basic idea is the password is automatically generated using a list of values stored in the tblvalues value field.

Is there anyway to do this - if it can't be done within Access maybe in ASP?

I have an asp page that adds a record to tblusers already and coould modify this.

Thanks in advance

Scott Lyndon