This sample shows the RelationKind.ForeignKeyReference relation.
Sets up a relation between two tables using a foreign key.
Implementation
The following is a sample code snippet showing this relation.
USStatesCollection usStates = USStatesCollection.CreateDefaultCollection(); this.engine1.SourceListSet.Add("Countries", countries); RelationDescriptor usStatesRd = new RelationDescriptor(); usStatesRd.Name = "State"; usStatesRd.RelationKind = RelationKind.ForeignKeyReference; usStatesRd.ChildTableName = "USStates"; // SourceListSet name for lookup. usStatesRd.RelationKeys.Add("State", "Key"); usStatesRd.ChildTableDescriptor.SortedColumns.Add("Name"); usStatesRd.ChildTableDescriptor.AllowEdit = false; usStatesRd.ChildTableDescriptor.AllowNew = false; // Make pencil icon disappear, users can't modify states. mainTd.Relations.Add(usStatesRd);