Datarelations

  • Thread starter Thread starter pleasehelp
  • Start date Start date
P

pleasehelp

Hi,

Could someone please explain how the datarelation object
works. I am getting very confused.

I have 3 tables

Document
Employee
EmployeeToDocumentRelationship

I have related these tables together (i think) using the
DataRelation object. I am unsure on how to traverse
throught the related data and find all documents that
belong to a specific employee.

please help..
thanks,

pleasehelp :0)
 
Theoretically speaking (you don't provide much information):

Depending on what you set up as whatevers parent you should be able to get
Parent/ChildRows with DataRow.GetParentRow/GetParentRows or
DataRow.GetChildRow/GetChildRows.
And with this you can get from one employee row to multiple rows in
employeetodocumentrelationship and from there to one of the associated
document rows.

So actually you don't need the Relationship Object to travel through the
tables after you have created the relationships.

hth
Uwe
 
Back
Top