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 |
|
ProjectName |
ParentTreeLeaf |
Display |
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 |