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

  • Thread starter Thread starter MitchB
  • Start date Start date
M

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.
 
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.
 
Back
Top