Really complete table relations ?
RFelsch
Member Posts: 3
Hi,
I'm searching for a list of relationships between tables(fields), which is really complete.
Concrete, I want to know all tables and fields, which relates to table 349 (Dimension Value), Field 2 (Code).
Tools like tbrowser are fine, but they work the other way round and rely on the table "Field", which seems not to be reliable. For example, the relation from table 17 (G/L Entry), field 23 (Global dimension 1 code) to table 349 is entered in the properties, but not registered in the table "Field".
Anyone with good hints? [-o<
Best regards
Ronald
I'm searching for a list of relationships between tables(fields), which is really complete.
Concrete, I want to know all tables and fields, which relates to table 349 (Dimension Value), Field 2 (Code).
Tools like tbrowser are fine, but they work the other way round and rely on the table "Field", which seems not to be reliable. For example, the relation from table 17 (G/L Entry), field 23 (Global dimension 1 code) to table 349 is entered in the properties, but not registered in the table "Field".
Anyone with good hints? [-o<
Best regards
Ronald
0
Comments
-
Import the objects in the developer toolkit, go the the field and use "where used" with all option on.
This gives a nice view of where it is used.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Thank you very much, that was helpful! :P0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions