Create a registration table for training

[Guest]

I have a table of names and ID's. I want to search the table by name to find
the ID and plug it into anther table with a course code.

I want to create a registration table for people taking a course so I can
print out certificates. The registration table will then link to the people
and courses to get a full name and course title and date to print
certificates.

 

[Guest]

From your description, I assume you don't want to do this through a form. If
that's the case, create an append query to insert records into your course
registration table. Add the employees table to the query and join the id
columns from the two tables. In the criteria row of the employee table's
name field put:
[Enter employee name]
This will prompt the user for a name and find a record in the employees
table. Then append the id column from the employees table to the id column of
the registration table.

I hope this is clear.
Barry

 

[ManningFan]

I think you need 3 tables:

tblUsers:
UserID
UserName

tblCourses:
CourseID
CourseName

tblClasses:
UserID
CourseID

Then put 2 combo boxes on a form, one of which reads the Users table
and one of which reads the Courses table. Set your combos so that they
are bound by the 1st column and display both colums. Set the column
sizes in the combo to be 0;3 (this way the ID column is actually
invisible). Put a button on the form that reads the values of both
combos and sticks them into tblClasses.

This should give you what you're looking for.

 

[ManningFan]

Barry -
Never give a user the opportunity to misspell a person's name. This
can create excessive bogus entries. Using a combo box is the safest
way to go.

From your description, I assume you don't want to do this through a form. If
that's the case, create an append query to insert records into your course
registration table. Add the employees table to the query and join the id
columns from the two tables. In the criteria row of the employee table's
name field put:
[Enter employee name]
This will prompt the user for a name and find a record in the employees
table. Then append the id column from the employees table to the id column of
the registration table.

I hope this is clear.
Barry

I have a table of names and ID's. I want to search the table by name to find
the ID and plug it into anther table with a course code.

I want to create a registration table for people taking a course so I can
print out certificates. The registration table will then link to the people
and courses to get a full name and course title and date to print
certificates.