Free E-Books

A new property
One of the things that bothers me about the Northwind Traders application is that it relies very
heavily on Access-only constructs. In particular, most of the tables, when viewed in datasheet view,
display related data. For instance, opening the Products table in datasheet view shows the product
category and supplier information, and not the ID values associated with each of these items.
For instance, the supplier name is shown in the Products table because the lookup properties of
the SupplierID field are set to display a combo box containing the supplier names.
We??™ve found these constructs to be confusing to users, especially people new to Access. Most
people, when they see the supplier??™s name in the Products table, expect to find the supplier
name among the data stored in the table. However, the only type of supplier information in the
Products table is the SupplierID. If the supplier name is required, you must extract it the
from the Suppliers table, using the SupplierID as the criterion.


Pages:
1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997