Field related to two tables

(0) Share

Report

Posted on by Arcadi

796

Hello,

I have a table with an int64 (no EDT) field, I want this field related to either the ERModelMappingTable or the ERFormatMappingTable (depending on an enum value).

In the form I have a reference group:

public Common lookupReference()
        {
            if(XYZ_ERTable.Direction == XYZ_Direction::Export)
            {                
                return ERFormatMappingTable::lookup(this, CustVendOutPaymConstants::modelName, CustVendOutPaymConstants::creditTransferContainerDescriptorName);
            }
            else
            {
                return ERModelMappingTable::lookup(this, classStr(ERTableDestination)   '#'   tableStr(XYZ_XYZ_HeaderTableEntity));
            }
        }

So the lookup filtering works great, but when selecting an ERFormatMapping (The second relation) I get the error:

So what I'm looking for a polymorphic lookup, also the field to show a descriptive text and not a RecId (already does that but I'm not sure how).

All responses (2)

Answers (0)

Sort by

André Arnaud de Cal... 307,097 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Arcadi,

You mentioned that the relation would depend on an enum value, but you haven't added the enum to the relations. You only used it to distinct the lookup. Ensure you will add the enum with the correct condition in the table relations for your two referenced tables.
Arcadi 796 on at

Like (0)

Report
Copy link

Link copied!

You are right André my relation was wrong and now works at a table level (With RecIds). But I'm getting the same error in the form. I think the reason is that I need to select a reference field in the reference group, So I have to choose between the fields of the format table or the fields of the model.