Contact Database

Varje Folder post har en ItemList kopplad till sig, denna Itemlist talar om vilka Items som ska finnas i gridden. Tex Foldern med FolderID 100 är ägare till alla poster i ItemList som har FolderID 100, och dessa posters IndexID talar om vilka Contacts som ska finnas i gridden.

Folder

Field Name

ParentFolder

FolderID

FolderName

ItemList

Field Name

Relats to

Description

FolderID

Folder.FolderID

IndexID

Conctacts.ContctsID

Primary Index

ProjectName

ParentTreeLeaf

Display

Fields

Fielda Name

DataType

Size

Description

ProjectName

Text

50

ContactsID

Long Int

DateRegistred

Date

DateModified

Date

Revision

Long Int

Changed_Since_Internet_Merge

Bool

Display

Text

65

Title

Text

5

FirstName

Text

20

MiddleName

Text

20

LastName

Text

20

Nickname1

Text

30

Nickname2

Text

30

Email1_Email_Adress

Text

50

Email1_Send_Using_Plain_Text

BOOL

Email1_ Comment

Text

50

Email2_Email_Adress

Text

50

Email2_Send_Using_Plain_Text

BOOL

Email2_Comment

Text

50

ICQ1

Text

10

ICQ2

Text

10

MSN_Messanger

Text

50

The hotmail email address.

Yahoo_ICQ

Text

20

Home_Street

Text

50

Home_City

Text

50

Home_State_Or_Province

Text

20

Home_Zip_Or_PostalCode

Text

10

Home_Country_Or_Region

Text

50

Phone1_Caption

Text

30

CarPhone

Phone1_Number

Text

40

Phone2_Caption

Text

30

HomePhone

Phone2_Number

Text

40

Phone3_Caption

Text

30

FaxPhone

Phone3_Number

Text

40

Phone4_Caption

Text

30

ISDNPhone

Phone4_Number

Text

40

Phone5_Caption

Text

30

PagerPhone

Phone5_Number

Text

40

Phone6_Caption

Text

30

BusinessPhone

Phone6_Number

Text

40

Phone7_Caption

Text

30

Business

Phone7_Number

Text

40

Birthdate

Date

Spouse_s_Name

Text

40

SpousesInterests

Text

100

Aniversary

Date

ChildrenNames

Text

255

Personal_Web_Page_1

Text

50

Personal_Web_Page_2

Text

50

Personal_FTP_Page_1

Text

50

Personal_FTP_Page_2

Text

50

Photograph

OLE Object

Company

Text

20

Business_Mail_Street

Text

50

Business_Mail_City

Text

50

Business_Mail_State_Or_Province

Text

20

Business_Mail_Zip_Or_PostalCode

Text

10

Business_Mail_Country_Or_Region

Text

50

Office_Location_Street

Text

50

Office_Location_City

Text

50

Office_Location_State_Or_Province

Text

20

Office_Location_Zip_Or_PostalCode

Text

10

Office_Location_Country_Or_Region

Text

50

Business_Web_Page_1

Text

50

Business_Web_Page_2

Text

50

Business_FTP_Page_1

Text

50

Business_FTP_Page_2

Text

50

Job_Title

Text

40

Department

Text

40

Office

Text

40

ManagerS_Name

Text

40

AssistentS_Name

Text

40

OtherS_Name

Text

40

UserField1

Text

60

UserField2

Text

60

UserField3

Text

60

UserField4

Text

60

Notes

Text

255