un existing Table is given as Table Relation for a Field

ajaybabuChajaybabuCh Member Posts: 208
Hi

"Table123456" is not in the database.
I have given Table Relation for a field as "Table123456" and I have compiled.
Navision compiled successfully without giving any error.


Other than Database Test,
Is there any other way to find out list of table objects whose fields are refering to non existing tables?

Thanks and Regards
Ajay

Comments

  • krikikriki Member, Moderator Posts: 9,110
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

    You can use table "Field" (a virtual table) to have some idea.
    In field "RelationTableNo" is the table to where a tablerelation points. But it is not complete. If you have a field (like "No." in table37:"Sales Line") that can point to different tables depending on the field "Type", field "RelationTableNo" will be 0.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.