Hi,

I have a simple table structure like this:

tblCulture -------> tblModuleString <-------- tblModule
CultureId PK CultureId FK ModuleKey PK
                     ModuleKey FK

So I have a 1 to many relationship between tblCulture.CultureId and tblModuleString.CultureId and a 1 to many relationship between tblModule.ModuleKey and tblModuleString.ModuleKey

Up to now I had only used datasets with two tables but now I have three tables in the relationship.

I have been able to create a dataset that will take care of the 1 to many relationship between tblModule.ModuleKey and tblModuleString.ModuleKey but I am not sure how to create the other relationship with the tblCulture.CultureId.

I would appreciate if someone could shed some light.

Cheers

// Set dataset table names
dataSet.Tables[0].TableName = "Module";
dataSet.Tables[1].TableName = "ModuleString";
// Create a data relation between the Module (parents) and ModuleString (children)
DataColumn parentColumn = dataSet.Tables["Module"].Columns["ModuleKey"];

DataColumn childColumn = dataSet.Tables["ModuleString"].Columns["ModuleKey"];

DataRelation moduleToModuleString = new DataRelation("ModuleToModuleString", parentColumn, childColumn);

dataSet.Relations.Add(moduleToModuleString);

Pallone:
It would help if you could define the "relationship" between a Culture and a Module. You have resolved the many-to-many relationship by using the junction table. According to ModuleStringTbl, you will be able to retrieve many cultureID and other culture information from the CultureTbl based on ModuleID and vice versa you will be able to retrieve many ModuleID and other Module Information from the ModuleTbl based on the ModuleID based on the CultureID associated with the ModuleID.

Hope this helps.

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Hi peace95,

Thanks for you reply.

In fact the information I need to get is all in tblModuleString. But I need to create the relationship between tblCulture.CultureId and tblModuleString.CultureId.

Cheers

Pallone:

I am going to try a different approach to the same idea: The objective is to establish a relationship between ModuleTbl and the CultureTbl, right? So let's do just that:
  CultureTbl>--------<ModuleTbl
   CultureID ModuleID This is a many-to-many relationship that says: "For each and every CultureID consists of 1 or more ModuleID". The reverse is also true, "For each and every ModuleID is made up of one or more CultureID". However, Many-to-Many relationships MUST BE resolved....hence the Junction Table, which is your ModuleStringTbl, which you created, sits between the CultureTbl and the ModuleTbl:
  CultureTbl---------<ModuleStringTbl>--------ModuleTbl
  CultureID ModuleID,CultureID ModuleID
What the above relationship states: "For each CultureID may consists of 1 or more ModuleIDs" and "For each ModuleID may consists of 1 or more CultureID"

In the above example there also exists relationships between the CultureTbl.CultureID and ModuleString.CultureID: "For each and every ModuleString.CultureID there exists 1 and only 1 CultureTbl.CultureID"; This relationship defines the CultureTble.CultureID as the LookupTbl as in a dropdownlist box. Also important is that as an administrator new CultureID's are added on the the CuluteTbl. The same is true for the ModuleTbl.ModuleID and the ModuleStringTbl.ModuleID.

Hope this helps.

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.