Understanding how someone setup table (1 Viewer)

Hi All,
I have a sample db for learning purposes.
It has 3 tables.
Customer
Orders
Products

The Customer table has a CustomerID field and it also has a "CompanyName" field
The Orders table also has a CustomerID field which is used to link to the Customer table.

The strange thing is - when I look at the Orders table in data-sheet view, all of the values that are populated within Orders.CustomerID are not displayed as the Customers.CustomerID values. What is displayed as Orders.CustomerID is in fact the "CompanyName" values from the Customers table.

I assume the person who set this db up must have set some option within Access to make it display the "CompanyName" rather than the "CustomerID" values.

There is nothing setup within the "caption" option of this field in the Orders table.
So I can't figure out what option does that?

Thanks in advance

Hi. Look under the Lookup tab while in the design view of the table. Incidentally, this is not a recommended practice.

Incidentally, this is not a recommended practice.

Click to expand...

To echo what DBGuy said.

Besides what you found out that what you see is not what is really there, here are other reasons we consider them Evil.
http://access.mvps.org/Access/lookupfields.htm

AH!
I should have looked there!
Yes that's exactly what is going on here.

And thanks very much for the best practices page on this also!

got_access:] said:

AH!
I should have looked there!
Yes that's exactly what is going on here.

And thanks very much for the best practices page on this also!

Click to expand...

Hi. You're welcome. We're all happy to assist. Good luck with your project.