Newbie help with relations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two tables in a dataset. I want to create a relation between the two
tables in which the child table can have foreign keys that do not match
primary key fields in the parent table. When the parent table is updated, I
want any related foreign key fields in the child table to be updated, but I
don't want any deletions to be cascaded. I've tried setting DeleteRule to
SetNull and UpdateRule to Cascade, but I get a constraint error on filling
the dataset in my program, I guess because most fields in the child table do
not have parent rows (but I don't want them to have parent rows). How do I
set this up in the dataset schema editor?

Thanks,
Nathan
 
I have two tables in a dataset. I want to create a relation between the
two
tables in which the child table can have foreign keys that do not match
primary key fields in the parent table.
Click to expand...
--This by definition goes against the definintion of a key unfortunately.

I guess because most fields in the child table do
not have parent rows (but I don't want them to have parent rows).
Click to expand...
--Again this is precisely the condition keys are supposed to avoid.

I think you're going to have to roll your own key so to speak, and trap
rowchanging/columnchanging and run validation on that. As far as keys go -
if you're going to have orphan records, all bets are off.
HTH,

Bill

Nathan M said:
Hi,
Click to expand...
When the parent table is updated, I
 
You can set the "Enforceconstraints" property to FALSE on your dataset
object, but as stated by WGRyan, you're going against the nature of
Parent/Child relations which is what the Dataset expects to handle.
 
Back
Top