• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

Table LookUp Field disconnect

I inherited a database.  In one of the tables there is a field that has a LookUp on the LookUp tab- a combo box pulling from another table.  I want to seperate that data into two fields.  If I delete the LookUp combobox I get the value for the field.  I need the value of the LookUp combobox too. Thanks.
1 Solution

Storing both the ID and the lookup Text in your table is redundant, and should not be done.

Rather than storing both peices of data in your table, you should store the ID field (as you are already), and use combo boxes or queries to display the text on the fly, as you need it.
Dale FyeCommented:

no points please.

to add to mbizup's comment, I'd go so far as to say that the "lookup" feature that MS added to the tableview in Access is one of the causes of confusion in most newbies, and which causes confusion for some of us that are more experienced, when working on someone elses database.  Because you don't see the actual value that is stored in the field (when using lookups), users get the impression that what is stored is the text, and when they write queries they try to use the text values rather than the actual numeric values.

Rather than using this feature, I would recommend that you delete the lookup from the table definition and create a query to view your data.  With a query you can join the two table on the appropriate field, and choose to display which ever fields you want, from either table.  This is the way relational database were meant to be viewed.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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