List Duplicate Value Issues Hub Model

Jojo88

Hello, 

 

In our hub model, we have a sales planning list (L1 Plants) with top level item All Plants. We have other sales planning list (L3 Profit Center) with top level item All Profit Centers

 

We have mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants. 

 

We have a new use-case where profit center rolls up to multiple plants. Mapping list will not accept duplicate (Profit center) under different plants. 

 

Ex:

Profit Center- Plant 

100505 - Plant A 

100506 - Plant B 

 

New Adj 

Profit Center- Plant 

100505 - Plant A 

100505 - Plant B 

100506 - Plant B 

This use case did not exist when our model was originally built. 

 

Looking for advice/information on how to adjust for this.