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
Thanks,
Laura
Product version: HealthShare 2019.1