DataSet Relations

[ronniek]

Hi,

I have two existing tables in a dataset
the two tables are in the usuall parent and child format

the program first fill in the tables and then I create the relation
the problem is that the parent table is missing some of the relation
values

normally a deleted primary key may cascade down and remove the child
records.
the case here is other.

I need to enforce a relation on two table so I can use the expression
to get
values from the parent table into the child table

p.s.
If there are no missing values in the parent table, the relation and
the expression work just fine
The problem arise only when I there are missing values in the primary
table

Please advise.

Ronnie

 

[Hussein Abuthuraya[MSFT]]

ronniek,

What you are seeing is "by design" and is called having Orphaned records in the child table. If a parent value is missing, then this would cause the existence of such records
and hence the DataRelation can't be created.

If you want to relate both tables, you have to have all the data in the Parent table before building a successful relationship.


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.