Query Help.

  • Thread starter Thread starter Tom Phethean
  • Start date Start date
T

Tom Phethean

I am trying to run a database whereby when a new member
enrolls, an enrolment key is assigned to that user - from
a list of pre-determined valid enrolment keys. Once this
number has been assigned to a user, i then want the user
name to appear next to the enrolment key in the table.
below is a simplified version of what i currently have:

enrolment table
enrolment key : username
123456 : user
789789 :
111111 :
etc

and user table:
username : name : email : enrolment key
user : bob : bob@Bob : (selected from drop down
list)

any ideas on how to acheive this would be much appreciated.
 
Many thanks for the method of doing it. Any possibility of
the VB code for such a procedure - im not quite up to that
level of coding yet.

Thanks again.
TP.
 
Back
Top