sometimes do this (add whole record in addcolumns). I create a coillection in several steps (collection on collection on collection) and in one stemp i might
add a column
"recProduct"; Lookup(Products;Id=SomeId)
and in a subsequent step I might add a column
"ProductMultilineFieldValue";recProduct.MultiLineField
In code where this worked for ages this was suddenly broken (recProduct.MultiLineField was blank, no errors or warnings) . When I reverted to a version of my app from a months ago where all was fine it was broken now too.
ThisItem.recProduct.Name still yields the correct result in a gallery, but ThisItem.recProduct.MultiLineField remains blank
What is the deal?
-You can do this and the fact it suddenly goed wrong is a bug
-You can do this at your won peril, it is not really supported and all might fall apart at some point
It is not that doing this suddenly does not work anymore anywhere but in one instance it fell apart.
(ps the data in the table is still fine, if I add all columns from fields in the products table by doing lookups one by one all goes well. The reason I do this, is that I think doing one lookup goes faster the doing ten.)
