Auto fill an Access Form based off of a section from another view

I have a form where I need to query a view (view has been added as an ODBC table) for a specific users full name.  Once the users full name is located, from the view, I want to grab the userid and populate it in another field that will update the table the form is designed form.  Can I do all of this on one form or will I have to have two forms?  Do my two tables (one table, one view) have to have a relationship established.

Hope this questions makes sense.