Hard to describe DataRelation

From: cyourch (cyourch_at_discussions.microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 08:01:03 -0800

Hi,

I have a DataRelation that I am having a hard time creating. I have 3
tables, one of which is a junction table (called 'TagAttribute'). The
junction table 'TagAttribute' relates XML tags to attributes where 1 tag can
have many attributes.

Aside from needing to create the DataRelation, what I also need to do is add
a DataColumn to the 'Attribute' table that has the 'Value' column from the
'TagAttribute' table. So, I also need the DataColumn.Expression I do this.

Here are the tables:
  Tag: tagID (PK), tagName
  Attribute: attributeID (PK), attributeName
  TagAttribute: tagID (PK,FK), attributeID(PK,FK), Value, DisplayOrder

Thanks!

Chris