Is it possible to do this. 1

[pbcharlie]

I have two tables. Users and names.
In users the fields are ID, Fname, Lname, Location, sex
in the names table I have Fname, lname and sex.

What I want to be able to do is have an insert query that inserts from the names table, however the names are randomly selected and also randomise the Fname, Lname combination to a predetermined number of records.

Is it possible and how?

Thanks in advance
Charlie

 

[Trendsetter]

Hi Charlie,
The tables you are working with are not truly normalised and the use of Fname & LName in a second table would just compound the potential problem.
If I have misunderstood what you are after please let me know!

 

[danvlas]

Actually, you have all the info you need in the users table. Why moving it to another table???
If you want to make some assignments table, all you need is the UserID from users table. Nothing else
Randomization can be made by :

Order By Rnd(UserID)

and a predefined number of records is set by the Top keyword:
Select Top 10 blah blah blah




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html