We have a problem similiar to http://syncfusion.com/Support/forums/message.aspx?MessageID=29631
How can we do the grid automatically import relations (foreign key lookup) specified in DataSet to display the values from the lookup table instead of foregn key?
ADAdministrator Syncfusion Team July 15, 2005 05:56 AM
What happens if you have 18 different relations based on one key column? What relation does the gridgrouping grid use?
Say you have a foriegn DataTable with ID, CompanyName, CompanyPresident, and a main DataTable that has an ID column. Your DataSet has 2 releation IDtoCompanyName and IDtoCompanyPresident. Which relation do you use in the Maintable for the ID column? It is the RelationKind.ForeignKeyReferences that you have to create that picks this out.
You could write a little method that loops through all the relations in your dataset and set up the appropriate RelationKind.ForeignKeyReferences objects, but you will have to decide on how you want to identify which relation you want to use when you have multiple relations based on the same key.
ANAndrewJuly 15, 2005 07:13 AM
Thanks! We have no multiple relations in our case, but I see, you are right.