In Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.2 (Build 309U) Mon Mar 4 2019 15:07:46 EST
I have a master record that has a relationship to a table with multiple transactions, and the transaction table has a relationship to another transaction table with multiple other transactions.
IE Item to Physcal to Physical Report
First transaction table
Relationship ItemRecord As User.immst [ Cardinality = one, Inverse = PhysicalRecord ];
Second Transaction table
Everything compiles with no issues and all records have the appropriate data (IDs).
In SQL why does
select pyrpt.pypqty,PhysicalRecord->pypqty as pypqty1, PhysicalRecord->ItemRecord->imdesc from SQLUser.pyrpt
return the imdesc field from the master table, but
select pyrpt.pypqty, PhysicalRecord->ItemRecord->imdesc from SQLUser.pyrpt
does not? Why do I have to force swizzling to occur for the two layer access to operate.
John P. Bland