How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask WesPCDr Your Own Question

WesPCDr, Information Systems Manager
Category: Microsoft Office
Satisfied Customers: 1479
Experience:  Microsoft Office Specialist
Type Your Microsoft Office Question Here...
WesPCDr is online now
A new question is answered every 9 seconds

Access Database 2010--I am creating a database with forms to

Resolved Question:

Access Database 2010--I am creating a database with forms to ease input of data. I am using lookup tables to create dropdown lists of values to choose from, and other values not in the drop down list maybe entered in the table that is referencing this lookup table. The list may change through the years so it will reflect the values chosen most often during that season of time. Question: is there any need to have a primary key field in the lookup table? There is only one field in the table. There is no reason for uniqueness--the records in the lookup table only provide possible choices for storage in a field in a "Client" table that does have unique records. All uniqueness is in the Client table and the values stored in that table's fields. Prefer to chat answers rather than e-mail back and forth if that works for you.
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  WesPCDr replied 4 years ago.

weshouck :

Hi, I can help answer your question.

weshouck :

You don't need a primary key for your lookup field as you describe it.

weshouck :

The primary key comes in handy when you want to change the words in the Lookup field and are linking by primary key. This way all the entries get changed instead of having to change all rows in the table.

weshouck :

Primary key: None
Lookup: My Client Name

weshouck :

If you wanted to change the lookup later on to "My Client Full Name" you can, however, you will then need to change the text in all your client table since it's not linked by primary key. If you had a primary key linked to the lookup, you would just change "My Client Full Name" in one place and it will automatically show the correct data in the client table.

weshouck :

The primary key is usually an auto incrementing number that you don;'t have to worry about.


Thank you, XXXXX XXXXX the "when" to use a primary key.

WesPCDr and 7 other Microsoft Office Specialists are ready to help you