Can I add a field on a page that is defined as a FieldRef?
I created a table with fields: TableNo, FieldNo and 'New Value'. I use the TableNo and FieldNo fields as RecRef and FieldRef to create a list of fields for the Item table (TableNo =27) and to be able to define a new value. This table is used for a batch update report to update the item table based on this table.
I created a page for this new table and I would like to have the option for the 'New Value' field to have the ability to do a lookup, the way these fields work on the Item table. (like an option field or lookup to a reference table, etc). I was trying to set it up as a FieldRef field as the 'SourceExpr' on the page, but that doesn't work.
Is that another way to achieve this?
Thanks.
0
Answers
Unfortunately a table relation property cannot be defined or changed dynamically at the run-time. In order to get it wok you would have to define massive conditional relation based on all possible combinations of Table No/Field No which you can possibly have in your field pair.
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03