Question Northwind

[florin]

Hi,

Why, in Northwind access2002 sample, in table products, field
SupplierID is number, but in table view is text (appear field CompanyName of
Supplier table)

 

[Allen Browne]

Open the table in design view.
Click in the SupplierID field.
In the lower pane of table design, click the Lookup tab.

You will see that the Display Control is set to Combo, and that it has a
query statement as the RowSource. This query returns 2 fields, and the
Column Widths are set so the SupplierID number is zero-width. Consequently
it shows the supplier name.

If you change the column width to a non-zero number (e.g. 0.5"), you will be
able to see the number.

Some of us find it unnecessarily confusing using a combo like this in a
table. Combos are great on a form, but it really confuses people when you
use them in a table as well, so that what you see is not what is actually
there.