Access 2007 View raw table with ID columns

Hi

In Access 2007 I am looking at the Northwind database at the table Orders.
At the moment I can see eg Employee rather than Employee ID. How do I view
the table with the IDs in certain columns?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
The table column uses a Lookup ...go to Table design (lookup tab) to change it from combobox to text box and you see the underlying value
Clipboard06.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
No points please.  Yet another reason that table level lookups are bad.  They obfuscate the actual value of a column so if two customers have the same name - John Jones but are actually different customers, you would never know it..
0
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks John and thank you Pat. I allocated no points as I think you wanted
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

John TsioumprisSoftware & Systems EngineerCommented:
I don't think Lookup is bad...its just not transparent....to end user....it tries to present human readable data on table data but probably it should include the info that what you see is not what it's stored...probably a simple switch when viewing the table would be most helpful
0
PatHartmanCommented:
You're welcome Murry.
John, So you're quite OK with two customers named John Tsioumpris, one good one bad both being reported as paying late?  That's the kind of stuff that happens when you obfuscate data.  Lookup fields are bad.  They are a crutch for people too lazy or too unknowledgeable to write a query.  Lookups belong on Forms (or reports) not on tables.  And for the same reason, I never format fields at the table level when that formatting could hide data.  For example, formatting a date field to show only the date and not the time could easily impede problem resolution if someone made the mistake of using Now() rather than Date() to put a date into the field.  If your query uses "=", that date with the time will never compare equal and unless you remember you formatted the table, you'll spin your wheels looking for the bug because you won't know that some, but not all, records include a time component.
0
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Pat that makes a lot of sense.  Lookups surely should not be used at table level. John I also see the point in making it more readable but as you say it would be nice to see both pieces of data
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.