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.
Great blogs. Thanks for sharing such great information on relationship. Loved your blog and looking forward to it.
ReplyDelete