SDPT3-2




		Firstly, create a database called SampleSDPOrders.cdb. The tables required for this application are listed below. Note: the "a" in the Auto column denotes this as an "AutoNumber" field. In order to create an AutoNumber field, you must create an Ascending index first. If you are using SprintDB Pro version 1.7 or higher, you should check the AutoField check box and choose "AutoIncremental" from AutoField dropdown box. For further information, see Creating Tables and New Auto field types.

Customers

Name

Type

Size

Indexed

Auto

CustomerID

Integer

-

ASC

a

CompanyName

Text

50

ASC

-

PhoneNumber

Text

30

NO

-

Notes

Memo

-

NO

-

Order Details

OrderDetailID

Integer

-

ASC

a

OrderID

Integer

-

ASC

-

ProductID

Integer

-

ASC

-

Quantity

Integer

-

NO

-

UnitPrice

Double

-

NO

-

Discount

Double

-

NO

-

Orders

OrderID

Integer

-

ASC

a

CustomerID

Integer

-

ASC

-

OrderDate

DateTime

-

NO

-

ShipName

Text

50

NO

-

ShipPhoneNumb er

Text

30

NO

-

Products

ProductID

Integer

-

ASC

a

ProductName

Text

50

ASC

-

UnitPrice

Double

-

NO

-


	Click the Next button to continue...