# Instructions

InstructionText:
Create a table called "Category" with the following fields:

CategoryID : AutoNumber, primary key
CategoryName: ShortText
Description: ShortText


InstructionText:
Create a table called "Todo" with the following fields:

TodoID: AutoNumber, primary key
TodoName: ShortText
Description: LongText
Priority: Number, acceptable values 1-5
DueDate: DateTime
Completed: Yes/No
Category: Number


InstructionText:
Create a table called "ProgressLog" with the following fields:

ProgressLogID: AutoNumber, primary key
Date: DateTime
TimeSpent: Number
Notes: LongText
TodoID: Number


InstructionText:
Close the tables.

Go to the Database Tools tab > Relationships.

Add all tables except for "Instructions" to the workspace.

Create a relationship from Category.CategoryID to Todo.CategoryID. Enforce referential integrity.

Create a relationship from Todo.TodoID to ProgressLog.TodoID. Enforce referential integrity.

Click save and close the Relationships tab.


