I have a quite of a problem. I am trying to design a page for NAV 2009 RTC, and I want to use the dropdown-feature.
Unfortunately, you only can set the source, what will be displayed in the dropdown, only if you configure the TableRelation.
The problem: The TableRelation is dynamic.
My current setup. I have two new tables. Attributes and ItemAttributes. The Attributes table has (besides other) a CODE and an OPTION (Text, File, Measure, List, Number, Url, YesNo, Item…)
I have created a sub-part list with lines for the Retail Item page (Item Attributes Sub). There are two fields on the sub page, “Attr. Code” and Value. Now there’s the tricky part. I want to use the dropdown feature on the Value field, while the user is typing and he see the suggetions. The problem, i can not resolute by now, If the user has defines “Attr. Code”, navision has to look up the Attributes table and the get the OPTION. If the option is (for example) List, it has the set the TableRelation to the table AttributeAllowedValues with a filter “Attr. Code”. If the OPTION is e.g. Item, it has to set the TableRelation to the Item table (with no filter). If the OPTION is Text, it has to lookup and check some other values from the Attributes table and then decide wether the TableRealtion is Table X with filter, Table Y with no filter or no TableRelation (no user assistance).
Which trigger do I have to edit, and how can i reset the TableRelation by C/AL