Ah, I should mention that this is happening in code that I can't access.  I can't really tel what's going on except by looking in the database after it's all "said and done". I can try that with one particular row in the database, but it's happening upstream, in othercode, and I'm wondering now if it's because the other code is possibly saving the Claim object differentlly.

However, this is a good idea.  I'll play arond with a couple of objects that are already in the database, and se if I can save them to be "right side up", and then "upside down" again.

I can't use

Select claim.ClaimNumber, line.ProcedureCode from Claim
JOIN ClaimLine line ON claim.ID = line.Claim

because there is no line.Claim value.

Global Masters badges:
Laura has no Global Masters badges yet.