thanks !! sorry I was not reading carefully enough !

you are really a life saver!

Hello! Peter, thanks for your reply!

But the problem is how can I run the script each time and just get a random result? for example, I run the script with...

thanks for the reply!!

sorry for the confusion, there are two tables, one is for first names with columns of names and gender, and the other table is for last names.and...