thanks that does help....I will read up on triggers and figure out what I need to do.

thank you for your post. I was not totally lost. I had tried cascade on delete first, but this gave me conflict. If you look at the...

OK I have tried more things to try to get this to work.

I tried the following:

client

ClientId UniqueIdentifer

ShipToAddress UniqueIdentifer null(fk)

BillToAddress UniqueIdentifer null(fk)

Then I tried to set both the rules

to delete...

thanks for the reply