Using Hierarchy with multiple values in tables

[#1]

Hi

I'm trying to use the Hierarchy key word in a structured multi lingual environment.

My source table is as below:

ID     Parent ID     Location_EN     Location_FR

1                         UK                    Royaume Uni

2     1                   London               Londres

The result I would like to get is:

ID   Parent ID   Location_EN1   Location_EN2  Location_FR1  Location_FR2

1                     UK                                         Royaume Uni

2    1               UK                    London           Royaume Uni   Londres

I tried doing two hierarchy on the same table, but the result is two tables instead of one

Message was edited by: Philippe Franck

[jvitantonio]

Can you please post your application with sample data?

[jagan]

Hi,

Please check the attachment.  Hope it helps you.

Regards,

Jagan.

[#4]

I attached a qvw file with some sample data.

[#5 · Accepted solution]

My solution: I placed 6 listboxes (one per language) with the 6 fields and hide the 5 unrelevant boxesby using the conditional display of objects based on current language.