Rlshp. Mgt. Comment Line

Diagrams

Table

Rlshp. Mgt. Comment Line

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Table Name (Table Name)	Option	[Contact,Campaign,To-do,Web Source,Sales Cycle,Sales Cycle Stage,Opportunity]
2	No. (No.)	Code20	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;
3	Sub No. (Sub No.)	Integer	TableRelation: IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage".Stage WHERE (Sales Cycle Code=FIELD(No.))
4	Line No. (Line No.)	Integer
5	Date (Date)	Date
6	Code (Code)	Code10
7	Comment (Comment)	Text80
8	Last Date Modified (Last Date Modified)	Date		Editable: No

Keys

#	Fields
0	Table Name,No.,Sub No.,Line No. (Table Name,No.,Sub No.,Line No.)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
No. (No.)	Campaign	No. (No.)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n
No. (No.)	Contact	No. (No.)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n
No. (No.)	Opportunity	No. (No.)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n
No. (No.)	Sales Cycle	Code (Code)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n
Sub No. (Sub No.)	Sales Cycle Stage	Stage (Stage)	TableRelation: IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage".Stage WHERE (Sales Cycle Code=FIELD(No.))	1..n
No. (No.)	To-do	No. (No.)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n
No. (No.)	Web Source	Code (Code)	TableRelation: IF (Table Name=CONST(Contact)) Contact ELSE IF (Table Name=CONST(Campaign)) Campaign ELSE IF (Table Name=CONST(To-do)) To-do ELSE IF (Table Name=CONST(Web Source)) "Web Source" ELSE IF (Table Name=CONST(Sales Cycle)) "Sales Cycle" ELSE IF (Table Name=CONST(Sales Cycle Stage)) "Sales Cycle Stage" ELSE IF (Table Name=CONST(Opportunity)) Opportunity;	1..n

Table Relations From Other Tables

From Table	From Field