Fill out part of a form from one table and submit to a second tabl

[MitchB]

I have an asset requisition database for our users to request new hardware or
software. The form asks them to fill in their name, email, the requested
items, and a justification for the purchase. This info is submitted to the
table "Request Information".

I would like to have the form ask them for their Clock# when it opens and
use this to fill in the name and email fields. This information is contained
in the table "Employee Info". I have a macro that will ask for the Clock#
when the form opens and it works as long as the only table this form is bound
to is the "Employee Info" table.

I need to know how to get the Employee name and email to submit to the
"Request Information" table along with other information the user is
submitting.

 

[Beetle]

You should not be trying to store employees name and email (or any
other attributes of the employee) in the Request Info table. All you need
is a Foreign Key field to store the Primary Key value from the Employees
table.

Then you can use a combo box on your form for the users to select
their Clock#. The combo box would be bound to the EmployeeID (FK)
field in the Request Info table, and it's Row Source would display
the Clock#'s from the Employee table.