Conditional relationship in Query

DenSter

A rare development question from me about conditional relationships in query objects.

Let's say I want to create a query based on the sales line table. Let's say I want to include the type and the No field, and I want to include a column for the name/description of the entity that the No. is linked to. So for Items I want to get the Item's Description from the Item table, for G/L Accounts I want to get the Name. Is there a way in the query object to put this as a conditional relationship into one column?

BardurKnudsen

No.
That type of construct requires unions, which we don't support.

DenSter

Alright thanks for the confirmation Bardur, I appreciate your time.