Hello,
it seems to be a great tool.
One Question:
How can I get access to client comprehensive tables?
With kind regards
Christian
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Christian,
Please forgive me but I am not familiar with the term "comprehensive tables" in NAV. Can you please clarify a bit more for me? -
Jet Reports Historic Posts Hi
I'm assuming the Christian means a full schema with table links in-place. I'm also assuming that this is not available.
It would be nice though. -
Jet Reports Historic Posts Thanks Collo!
The Table Builder in Jet Express will give you access to all of the tables within your NAV 2009 database. Without getting into ugly details, if there is only one field that links the tables together, this relationship will automatically appear in the Table Builder. If more than one field is needed to link the tables together, you will not see a relationship there automatically. You can test this by creating a report that links the Customer table to the Cust. Leger Entry table. The link is already set for you. (This is because these tables are linked by the customer number.) But if you create a report linking the Sales Header to the Sales Line table, a link will not be there. (This is because these tables are linked by the document number and the document type.)
I hope this makes sense and answers your question! -
Jet Reports Historic Posts Hi Christian,
The attached report might be what you're after if I understand your question correctly.
This includes information about all the fields and tables in your database and field relationships.
You''ll need to refresh this report to get data for your database.
Hope this helps.
Steve
Please sign in to leave a comment.