Fault/Resol. Cod. Relationship

Diagrams

Table

Fault/Resol. Cod. Relationship

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

Fields

#	Name	Type
1	Fault Code (Fault Code)	Code10	TableRelation: "Fault Code".Code WHERE (Fault Area Code=FIELD(Fault Area Code), Symptom Code=FIELD(Symptom Code));
2	Symptom Code (Symptom Code)	Code10	TableRelation: "Symptom Code"
3	Fault Area Code (Fault Area Code)	Code10	TableRelation: "Fault Area"
4	Resolution Code (Resolution Code)	Code10	TableRelation: "Resolution Code"
5	Occurrences (Occurrences)	Integer		Editable: No
6	Description (Description)	Text80
7	Service Item Group Code (Service Item Group Code)	Code10	TableRelation: "Service Item Group"
8	Created Manually (Created Manually)	Boolean		Editable: No

Keys

#	Fields
0	Fault Code,Fault Area Code,Symptom Code,Resolution Code,Service Item Group Code (Fault Code,Fault Area Code,Symptom Code,Resolution Code,Service Item Group Code)		Clustered: Yes
1	Fault Code,Occurrences (Fault Code,Occurrences)
2	Fault Area Code,Occurrences (Fault Area Code,Occurrences)
3	Symptom Code,Occurrences (Symptom Code,Occurrences)
4	Service Item Group Code,Fault Code,Occurrences (Service Item Group Code,Fault Code,Occurrences)

Table Relations To Other Tables

Field	Related Table	Related Field
Fault Area Code (Fault Area Code)	Fault Area	Code (Code)	TableRelation: "Fault Area"	1..n
Fault Code (Fault Code)	Fault Code	Code (Code)	TableRelation: "Fault Code".Code WHERE (Fault Area Code=FIELD(Fault Area Code), Symptom Code=FIELD(Symptom Code));	1..n
Resolution Code (Resolution Code)	Resolution Code	Code (Code)	TableRelation: "Resolution Code"	1..n
Service Item Group Code (Service Item Group Code)	Service Item Group	Code (Code)	TableRelation: "Service Item Group"	1..n
Symptom Code (Symptom Code)	Symptom Code	Code (Code)	TableRelation: "Symptom Code"	1..n

Table Relations From Other Tables

From Table	From Field