Access 2007 How to change a form that updates a table

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?
Scarlett20Asked:
Who is Participating?
 
Helen FeddemaCommented:
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
 
Scarlett20Author Commented:
Helen - thanks so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.