Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

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.
0
Elroy Taulton
Asked:
Elroy Taulton
1 Solution
 
dqmqCommented:
One form should do.  If I understand your intent correctly, the tables needn't have a data relationship, as you are establishing a relationship by a manual process of searching the view.  However, if you do have a relationship, than the assignment can be automated so you don't need to do it manually.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now