?
Solved

Access 2007 How to change a form that updates a table

Posted on 2011-09-21
2
Medium Priority
?
210 Views
Last Modified: 2012-05-12
I'm new to access, so this question is probably simple.  I'm looking at a db someone else created.  It has table "location" containing ID (autogen'd), and location name(text). There is a form that creates/updates records in another table - let's call it "targetA".  This form contains a dropdown allowing users to pick a location.  The user picks a location name (text), and the corresponding ID number is posted to targetA.  Where/how do I change it so the location name gets posted to targetA instead of the ID?
0
Comment
Question by:Scarlett20
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 1000 total points
ID: 36577215
Instead of posting the location name to targetA, just post the ID.  That is proper technique for a normalized database.  You can display the name on the form (and elsewhere) using the linking field.
0
 

Author Closing Comment

by:Scarlett20
ID: 36930925
Helen - thanks so much!
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question