page field by field reference

RoelofRoelof Member Posts: 377
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.
Roelof de Jonghttp://www.wye.com

Answers

  • Jan_VeenendaalJan_Veenendaal Member Posts: 206
    You will need to code this, probably in the OnLookup trigger of the page. You can't do this using properties.
    Jan Veenendaal
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    Build-in lookups are working using the table relation information defined on a field in the table.

    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.

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.