.com Solutions Inc. - logo  
Products - Header Buttons
.
Repgen bullet item 7b Installgen bullet item 7b FmPro Migratorbullet item 7b CGIScripter
 .
.
.

. 		.

FmPro Migrator - Oracle Files - Title Graphic

FmPro Migrator Features and Benefits

FmPro Migrator Demo Available for download...

Bookmark This Page

email a friend

.

Contact_Management.fp5 Database Structure Report

Copyright 2003 by .com Solutions Inc.

This output file was created by FmPro Migrator version 1.23 on Thu Apr 3 12:21:05 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net

----------------------- Database Summary --------------------------

FileMaker Version: FileMaker Pro 5.5v1 Dev
FileMaker Database Name: Contact_Management.fp5
Fields: 40
Layouts: 15
Scripts: 23

----------------------- Fields Summary --------------------------
Number of Fields: 40

Field Name Type Primary Key
Last Name text no
First Name text no
Company text no
Title text no
Street 1 text no
City 1 text no
State Province 1 text no
Postal Code 1 text no
Notes text no
Phone 1 text no
Date Created date/time no
Date Modified date/time no
Identification Number text no
Image Data container no
Template Information Global text no
Created By text no
Last Layout number no
Email text no
Phone 2 text no
Current Date date/time no
Similar By text no
Similars Key text no
Similars MultiKey text no
Similars Count number no
Similars Tab Label text no
Similar Name Key text no
Similar Company Key text no
Street 2 text no
City 2 text no
State Province 2 text no
Postal Code 2 text no
Address Type 1 text no
Address Type 2 text no
Scratch text no
Thumbnail container no
Contact ID number no
Most Recent Form Layout number no
Letter Body Text text no
Email Address with Name text no
Thumbnail Display container no



----------------------- Fields Detail --------------------------

Note: Long formulas usually wrap around to the next text line. The info presented here has been HTML formatted for improved readability.

Name ID FileMaker Type Empty Values Unique Values Repeating Global Access Protection Calculation
Last Name 2 text Empty Ok Not Unique No No read/write formulas protected  
First Name 4 text Empty Ok Not Unique No No read/write formulas protected  
Company 7 text Empty Ok Not Unique No No read/write formulas protected  
Title 12 text Empty Ok Not Unique No No read/write formulas protected  
Street 1 15 text Empty Ok Not Unique No No read/write formulas protected  
City 1 16 text Empty Ok Not Unique No No read/write formulas protected  
State Province 1 17 text Empty Ok Not Unique No No read/write formulas protected  
Postal Code 1 18 text Empty Ok Not Unique No No read/write formulas protected  
Notes 19 text Empty Ok Not Unique No No read/write formulas protected  
Phone 1 21 text Empty Ok Not Unique No No read/write formulas protected  
Date Created 24 date/time Empty Ok Not Unique No No note read only  
Date Modified 25 date/time Empty Ok Not Unique No No note read only  
Identification Number 31 text Empty Ok Not Unique No No read/write formulas protected  
Image Data 41 container Empty Ok Not Unique No No read/write formulas protected  
Template Information Global 44 text Empty Ok Not Unique No Yes read/write formulas protected  
Created By 45 text Empty Ok Not Unique No No read/write formulas protected  
Last Layout 46 number Empty Ok Not Unique No Yes read/write formulas protected  
Email 67 text Empty Ok Not Unique No No read/write formulas protected  
Phone 2 68 text Empty Ok Not Unique No No read/write formulas protected  
Current Date 76 date/time Empty Ok Not Unique No No note read only Status(CurrentDate)
Similar By 77 text Empty Ok Not Unique No Yes read/write formulas protected  
Similars Key 78 text Empty Ok Not Unique No No note read only Case(
Similar By = \"Name\",
Similar Name Key,
Similar By = \"Company\",
Similar Company Key,
Similar By = \"City\",
City 1,
\"\")
Similars MultiKey 79 text Empty Ok Not Unique No No note read only Similar Name Key & \"¦\" &
Company & \"¦\" &
City 1
Similars Count Empty 80 number Empty Ok Not Unique No No note read only Count(Similars::Similars Key)
Similars Tab Label 81 text Empty Ok Not Unique No No note read only \"Related Contacts\" &
If(Similars Count,
\": \" & Similars Count & \" by \" & Similar By,
\"\")
Similar Name Key 82 text Empty Ok Not Unique No No note read only Last Name
Similar Company Key 83 text Empty Ok Not Unique No No note read only Company
Street 2 84 text Empty Ok Not Unique No No read/write formulas protected  
City 2 85 text Empty Ok Not Unique No No read/write formulas protected  
State Province 2 86 text Empty Ok Not Unique No No read/write formulas protected  
Postal Code 2 87 text Empty Ok Not Unique No No read/write formulas protected  
Address Type 1 88 text Empty Ok Not Unique No No read/write formulas protected  
Address Type 2 89 text Empty Ok Not Unique No No read/write formulas protected  
Scratch 90 text Empty Ok Not Unique No Yes read/write formulas protected  
Thumbnail 91 container Empty Ok Not Unique No No read/write formulas protected  
Contact ID Not Unique No No 92 number Empty Ok Not Unique No No read/write formulas protected  
Most Recent Form Layout 93 number Empty Ok Not Unique No Yes read/write formulas protected  
Letter Body Text 94 text Empty Ok Not Unique No Yes read/write formulas protected  
Email Address with Name 95 text Empty Ok Not Unique No No note read only First Name & \" \" & Last Name & \" <\" & Email & \">\"
Thumbnail Display 96 container Empty Ok Not Unique No No note read only If(
IsEmpty(Thumbnail),
Image Data,
Thumbnail
)

----------------------- Layouts Summary --------------------------
Layouts: 15

Name ID Visible Access Protection Lock Status
Form - Main Address 1 Yes read/write formulas protected unlocked
List 2 Yes read/write formulas protected unlocked
Information 4 Yes read/write formulas protected unlocked
- 8 Yes read/write formulas protected unlocked
Form - Second Address 11 Yes read/write formulas protected unlocked
Form - Similars 14 Yes read/write formulas protected unlocked
Letter 17 No read/write formulas protected unlocked
Web List 19 No read/write formulas protected unlocked
- 20 No read/write formulas protected unlocked
Web Form 21 No read/write formulas protected unlocked
Avery 5160 22 No read/write formulas protected unlocked
- 23 No read/write formulas protected unlocked
Table 37 No read/write formulas protected unlocked
List Report 38 No read/write formulas protected unlocked
Letter: Address Confirmation 40 No read/write formulas protected unlocked

----------------------- Layout Details For Layout: Form - Main Address --------------------------
Number of Fields: 14
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Street 1
Address Type 1
City 1
State Province 1
Postal Code 1

----------------------- Layout Details For Layout: List --------------------------
Number of Fields: 5
Field Name

First Name
Company
Thumbnail Display
Phone 1
Title

----------------------- Layout Details For Layout: Information --------------------------
Number of Fields: 1
Field Name

Template Information Global

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Form - Second Address --------------------------
Number of Fields: 14
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Street 2
Address Type 2
City 2
State Province 2
Postal Code 2

----------------------- Layout Details For Layout: Form - Similars --------------------------
Number of Fields: 12
Field Name

First Name
Company
Image Data
Title
Phone 1
Phone 2
Email
Notes
Similars Tab Label
Similar By
Similars::First Name
Similars::Company
Note1

----------------------- Layout Details For Layout: Letter --------------------------
Number of Fields: 2
Field Name

Current Date
Letter Body Text

----------------------- Layout Details For Layout: Web List --------------------------
Number of Fields: 5
Field Name

First Name
Last Name
Title
Company
Phone 1

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Web Form --------------------------
Number of Fields: 14
Field Name

First Name
Last Name
Phone 1
Company
Title
Email
Street 1
City 1
State Province 1
Postal Code 1
Phone 2
Date Modified
Image Data
Notes

----------------------- Layout Details For Layout: Avery 5160 --------------------------
Number of Fields: 1
Field Name

Postal Code 1

----------------------- Layout Details For Layout: - --------------------------
Number of Fields: 0
Field Name


----------------------- Layout Details For Layout: Table --------------------------
Number of Fields: 15
Field Name

First Name
Company
Title
Phone 1
Email
Notes
Street 1
City 1
State Province 1
Postal Code 1
Phone 2
Street 2
City 2
State Province 2
Postal Code 2

----------------------- Layout Details For Layout: List Report --------------------------
Number of Fields: 3
Field Name

Title
Company
Phone 1

----------------------- Layout Details For Layout: Letter: Address Confirmation --------------------------
Number of Fields: 1
Field Name

Current Date

----------------------- Scripts Summary --------------------------
Number of Scripts: 23

Name ID
View Contact List 7
Open Script 10
- 11
Dial Extension 12
Dial Home Phone 13
Dial Emergency Phone 14
Find 15
Go to Information Layout 16
Go to Reports Layout 18
Write Letter 20
Avery 5160 22
- 36
- 38
Go to List Layout 39
Your Own Report 40
Go to Form Layout 41
Go to Table Layout 43
Swap Main and Second Addresses 44
Write Letter to Main Address 45
Send Email 46
Go to Form Layout 1 47
Go to Form Layout 2 48
Go to Form Layout 3 49


.

hline

 . .

.

 . .
 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices
.
.   .
.
Home Products Services Downloads Order Support Contact