When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.
The tag in question is the "UDFTBL" tag.
This particular field uses validation to perform a query lookup against a UDT. This allows a user to select a value from that field (this was basically what UDTs are designed to do), but I am now wondering if I can create another multi-line field using any random field to start with, but manipulate the tags within it to perform a "FIND" in another column within that UDT - if provided a key.
So in another field, if I could change the UDFTBL tag to: UDFTBL=AR_UDT_CUSTOMER_AP_PORTALS
, is it possible to pass the UDT's key field and retrieve the column UDF_AP_PORTALDESC
within that UDT?
I've tried the following and some of it may be correct (likely not) and I could just be missing additional tags:
- FIELD=<KeyValue>
- KEY=<KeyValue>
Along with UDFCOL=UDF_AP_PORTALDESC
So a full example that I've tried would be UDFTBL=AR_UDT_CUSTOMER_AP_PORTALS;FIELD=OPENINV$;UDFCOL=UDF_AP_PORTALDESC
But I am not having any success. I know I can use probably use the UDT_Maint BOI in an event script to load this, but I am very curious if this can work without scripting. The fact that UDFTBL allows pointing to a specific table makes me think that this should work and I prefer to not use a script if there's an alternative, I just don't know a lot about Nomads tags.
And just to clarify, I am only wanting to perform a lookup/FIND. I am not attempting to update data in the UDT (so this field will be disabled to the end user). I will still likely update the UDT via a script when that is needed.