Avatar

Correct answer by
Community Advisor

Hi Bruno,

The error displayed may depends on the schema source definition for your satellite tables, dblink, if you used reverse link or not, etc.

Please describe how you manage the relationship depending on the cardinality 0:n or 0:1 or n:n, with reverse link or not (reverseCardinality, etc) ?

Please in case of elements of type link, most of time used for lookup tables (referential tables) values to display in the main form (here recipient), may you also share the <join xpath-dst="@DSTKEY_ID" xpath-src="@SRCKEY_ID"/> in the element of type="link" of the schema customized cus:recipient (or whatever the prefix)?

But it seems that it is not your issue in your case.

Example with my own nms:recipient form:

<!-- Shop orders -->

  <container img="nms:reserveOrder.png" label="Shop orders" readOnly="true">

    <container colspan="2" label="Shop orders list" type="visibleGroup" visibleIf="[SHOP_ORDERS-Nms-Recipient_XXX_ID/@XXX_ID]= [InfosYYY/@MasterId] AND [SHOP_ORDERS-Nms-Recipient_XXX_ID/@XXX_ID] != 0">

(XXX and YYY replacement for security reasons.).

Moreover, most of times, it is highly recommended to insert a record with ID = 0 value in each satellite table, because Adobe Campaign simulates external join to avoid performance issues.
I don't find easily where it is written in the online documentation, but I am sure this is documented.

Regards
J-Serge

View solution in original post