The last implementation is for the cross-reference structure of the color data.
As the previous diagram shows, two tables will be created. The first will be
ModelXREFColor, which holds the color and model IDs. The second table will
hold the color data. Tables 2-11 and 2-12 show the data types for the fields.
Next, create the tables in Access. For the ModelXREFColor table, the primary
key is the combination of the two fields: ModelID and ColorID. Highlight both
28
Microsoft Office Access 2003 Professional Results
Win&Mac / Microsoft Office Access 2003 Professional Results / Jerke / 222965-9 / Chapter 2
FIGURE 2-3
Makes table
Field
Data Type
CategoryID
Autonumber – Primary Key
ParentCategoryID
Number – Long Integer
Name
Text – size 50
TABLE 2-10
Category Table Fields
P:\010Comp\Win&Mac\965-9\ch02.vp
Wednesday, August 06, 2003 10:03:26 AM
Color profile: Generic CMYK printer profile
Composite Default screen
|
|