page field by field reference

Roelof

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.

Jan_Veenendaal

You will need to code this, probably in the OnLookup trigger of the page. You can't do this using properties.

Slawek_Guzek

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.