Excel Importer - Lookup using multiple columns value

Question

Hi,

I'm using the LightSwitch ExcelImporter and I'm having a problem on importing data when there are two relationships in the entity and the second is the details of the first.

I've the Customer entity and it contains a relationship to the Country entity plus another relationship to the Region entity that is a details of Country. If the Region entity contains more values with the same code, the tool generate a message saying that there are multiple occurrencies in the Regions table for the given value and that the first occurency will be used. This can happen if the region code is the same in reference to two differen countries.

Is there a way to specify to the tool that when it is looking for the Region to consider also the value in the Country?

Thanks

Antonio

Answer 1

Refer to this link

http://social.msdn.microsoft.com/Forums/en/lsextensibility/thread/8c92425d-9025-4395-b129-4ec521abffb5