· Oct 26, 2022

One-to-many relationship not ordered as expected

Hello all; I am using a one-to-many relationship.  I have a Claim (one), in a relationship with Lines (many), but the Claim is storing a list of Lines IDs, rather than the Lines storing the Claim Id.  This seems upside down, and not what I expected.

Class Claim

    Relationship ClaimLineRel as ClaimLine [Cardinality = many, Inverse = Claim];

Class ClaimLine
    Relationship Claim as Claim [ Cardinality = one, Inverse = ClaimLineRel, OnDelete = cascade];
    Index ClaimIndex on Claim;

But the storage globals for Claim show data in the ClaimLine spot:

^ClaimD(1)=$lb("",$lb(2,3)... etc.)


while the ClaimLine storage has nothing int he Claim spot:

^ClaimLineD(2) = $lb("","",... etc)

How can I force the relationship to use the Claim as the "parent' without using a parent-child relationship?  

Id like to be able to use the SQL:


Select Claim->property from ClaimLine



Product version: HealthShare 2019.1
Discussion (3)1
Log in or sign up to continue

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.