How do I know which is the Parent in a Join?

Here’s how to decide the parent/child relationships for joins:

PIESCentral expects that for each row in the parent table, there is at most one row in the child table.

For example, if you make SupplyChainData the parent and AttributeList the child, you will get 4 or 5 child rows for each parent row. That doesn’t work.

If you make AttributeList the parent and SupplyChainData the child, you will get at most one child row for each parent row (as required). Setting “Remove Null Rows” will remove rows from the join where the part does not exist in SupplyChainData.

When the “remove where null” option is checked, it makes the join work like an inner join. Parent rows with no corresponding child are removed.