Need help

jpk4077

Hi,

Is there any system table which gives me the conditional relation of fields. The Fields table maintains RelationTableNo, RelationFieldNo for each field relation only if it does not have a conditional relation.

Secondly is there any system table which gives me the keys of a table. Due to some limitations I cant use keyref or recordref variables.

Tx n Regards JPK

NaviTools.com

Hi,

Conditional relations to fields aren't available in Navision tables. However if you have access to Navision Developer Toolkit (NDT), you can find them in table 99003608 Relation to Table.

In Navision there is also no table that has information about table keys. In NDT there is table 99003607 Key.

jpk4077

dont u feel shattered when navision gives u access to features like fields, tables, company/lic info etc. and then backs out when things slightly complicated.

It really sucks at times.

Sorry if tht was rude. JPK

mjrogers

Hey! We consultants have got to be able to make our money somehow!