Aggregate from several values

[#1]

Hello,

I will ask you a question about an aggregate of suppliers.

You can see in the excel file join to this message that I have several supplier names for several sites.

Sites A, B, C are loaded from databases, but Supplier Aggregate is loaded from an Excel file and represent the name of one supplier.

If we select EATON, we must have EATON A, B and C selected.

Do you know how do I get to do that?

For the moment, I named Suppliers field from Excel and Database as [Supplier Name], but with this I lost the aggregate name "EATON" and have only EATON A, B and C.

Thanks for your help !

[#2]

Allow me to ascend the topic, if someone can help me ?

Thanks !