Multiple fields populating a form

[Guest]

I am trying to create a form that adds a new record to a table. The issues is
that i dont want to store the full name of a user i just want to store the
user id. However the person entering data only knows the full name. Is there
a way to have a form that populates a userid field in table2 from the
selection of a full name drop down. I would like the data to show up as if it
was all one form without the look of a subquery. Thank you.

 

[Guest]

Hi Eddie
Convert that text box to the combo box. In the row sourece bring the data
form the table wher the names are stored along with the ID that is associated
with it. Keep the ID in the first colm and name in the second colamn. In
column count put 2. In the column width enter 0; 1;. In Bounded column put 1.
Now save the form and it will do the trick of showing the name on the form
but store the ID Value in the table.