Skip to main content

Dataset Relationships Tracker

If you want to build some custom repots and queries you have to know how to create joins 
between tables so you will need the Dataset Relationships Tracker.

Dataset Relationships Tracker is a dashboard which displays the relationships between Epicor datasets.

For example: If you want to know all child data table for Part table so you will type Part in parent data table text box and press Refresh button in the toolbar and you will get all child data tables and child fields which help you to create joins between tables.




If you want to know how to join between Part and PartUOM tables so you will type Part in parent data table textbox and PartUOM in child data table textbox and the click on the refresh button in 
the toolbar and you will get the child fields which join the two tables.


Labels:

Comments

  1. Couple Monitor8 June 2019 at 07:23

    Great blogs. Thanks for sharing such great information on relationship. Loved your blog and looking forward to it.

    ReplyDelete

Post a Comment

Popular posts from this blog

Automatic Login to Epicor

Overview: When the user double-clicks on the program icon in the desktop, Epicor Login window will appear and ask the user to enter the user name and password. But you can modify the configuration setting file so the user can automatically login into the application.
1 comment
Continue reading →

How to use Process Sets Maintenance

The process sets program uses to group a list of task together to be run in a schedule and you can order the task to be run in your order especially if you have a task depend another task.
3 comments
Continue reading →