Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community
Forums » Microsoft Dynamics AX / Axapta » AX / Axapta - Developer Forum » Table Relations

Table Relations

rated by 0 users
This post has 2 Replies | 3 Followers

Not Ranked
Posts 1
Points 35
Member since 09-18-2007
Reply
ahartong Posted: 09-18-2007 23:22

I've seen this post several times, but real solutions.  I am looking to find, or run some report generation tools, or something in the SDK that shows a table and all of its realtions.

One example would be the SalesTable table.  It lists its relations, but that is what is only setup as a relation in the AOT.  I am looking for something listing the SalesTable table, and all of the true related tables, like the line items table, taxes, serial numbers, commissions, etc.  There does not seem to be a way to determine what tables are written to when sales orders are created, or any other document for that matter.

Any help is appreciated.

 

  • | Post Points: 35
Top 75 Contributor
Male
Posts 247
Points 2,400
Member since 03-23-2005
Moderator
Reply
Kashperuk Ivan replied on 09-20-2007 8:25

You can try using cross-references.

The information for tables is stored in xRefTableRelation.

Information about Table Relations is gathered there

There is no document describing all of this. Sorry :)

Kashperuk Ivan (Vanya)
My blog
Dynamics AX links
Top 10 Contributor
Male
Posts 5,421
Points 67,563
Member since 04-12-2001
DynamicsNAVMVP
Moderator
SystemAdministrator
Reply
David Singleton replied on 10-05-2007 0:59

Hey ahartong welcome to The Dynamics User Group, but especially congratulations on starting the 20,000th Thread Cake  Party!!! Beer

David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistance
Dynamics Book
  • | Post Points: 5
Page 1 of 1 (3 items) | RSS

Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.