Datasheet

Table 1-6: Projects Table Fields
Field Name Data Type Data Type Attributes
ProjectID Number Field Size = Replication ID, Required =
Yes, Indexed = Yes (No Duplicates)
ProjectName Text Field Length = 50, Required = Yes, Allow
Zero Length = No
ProjectDescription Memo Required = No, Allow Zero Length = No
SequenceNumber Number Field Size = Byte, Required = Yes
LastUpdateDate Date/Time Required = Yes
11. Click ProjectID in the Field Name column and then click the Edit menu and choose the Primary
Key menu item or click the Primary Key icon on the toolbar to set this field as the primary key
for the table.
12. Click the File menu and choose Save or click the Save icon on the toolbar. In the Save As dialog
box, enter a name of Projects and then click OK.
13. Close the table designer by clicking the X in the upper-right corner of the window.
14. The next table that you want to create is the GroupProjects table. Double-click Create table in
Design view to open the table designer. Enter the field names, data type, and data type
attributes as shown in Table 1-7.
Table 1-7: GroupProjects Table Fields
Field Name Data Type Data Type Attributes
GroupProjectID Number Field Size = Replication ID, Required =
Yes, Indexed = Yes (No Duplicates)
GroupID Number Field Size = Replication ID, Required =
Yes, Indexed = Yes (Duplicates OK)
ProjectID Number Field Size = Replication ID, Required =
Yes, Indexed = Yes (Duplicates OK)
15. Click GroupProjectID in the Field Name column and then click the Edit menu and choose
Primary Key or click the Primary Key icon on the toolbar to set this field as the primary key for
the table.
16. Click the File menu and choose Save item or click Save. In the Save As dialog box, enter a name
of GroupProjects and then click OK.
17. Close the table designer by clicking the X in the upper-right corner of the window.
18. You now need to create a relationship between the GroupProjects table and the Groups and
Projects tables. Click the Tools menu and choose Relationships or click the Relationships icon.
18
Chapter 1
04_58894x ch01.qxd 10/13/05 5:54 PM Page 18