The standard ms-access example, North-wind database, has a great feature that I cannot duplicate in my databases. The North-wind database has
A table “Orders” with fields including
. OrdersId
. ShipVia (Long Integer: could be called ShippersId)
A Table “Shippers”
. ShippersId CompanyName Phone
. 1 BestShipping 9123-5677
2 QuickShip 6789-1234
When I open north-wind database and view the table “Orders”, the ShipVia field, an integer field, does not show the number “2”, it shows the company name “BestShipping”
When I carefully try to define a similar structure in my database, I get what I would expect. When I open my equivalent of the “Orders” table, I see only a number in my equivalent field of ShipVia.
Running Access 2007 with Windows 2007 64 bit