Import one table more than once in one RDD?

Epicor ERP 10
1

Is there any way to use one table more than once in a RDD.
For instance, Can Customer table be used twice to associate with OrderHead with two relationships, one using CustNum and the other using BTCustNum?
Thanks.

2

I have not figured out a way to do add the same table twice to an RDD and join to it differently. Instead, I’ve had to get creative about other ways to get to the data I want.

One way is the linked tables tab for each table, allowing you to reach out to a table based on the key value in the parent table. That should work for one or more of your customer table needs, depending on what is in the list of available link fields.

Another solution when the picked links don’t provide what you need is to get creative about your data. Sometimes Epicor stores things redundantly, so another table might have the same thing. For example, the customer’s address is also in the ShipTo table where ShipToNum is blank.