Random or sequential allocation!

[Learner520]

hi everybody, i have two tables student and supervisor 1-Student studentId studentname 1 john 2 paul 3 Martin 4 tony . . . 14 Mike 2-Supervisor SupervisorId supervisorName 1 Mark 2 Rodney 3 Wilson 4 Sarah 5 Raj 6 Neil 7 David i hav 14 students and 7 supervisor i have to allocate each supervisor to 2 students. please could anyone tell me how i can allocate 1 supervisor to 2 sutdents or how can i display output as Allocation Table like this Allocation Table AllocationId Student Supervisor 1 1 1 2 2 1 3 3 2 4 4 2 5 5 3 6 6 3 7 7 4 . . . . . . . . . 13 13 7 14 14 7 thanks for any kind help in adv. regards learner

[Ashfield]

So didn't you understand the answer the first time you asked? If not, try responding to the original post, not starting a new one.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP