join multiple tables but show one field

DiabloRito

Hello.
I have 5 tables :
T1(key1, field11, field12)
T2(key2, field21, field22)
T3(key3, field31, field32)

T4(key4, RefKey1, RefKey2, field41, field42)
T5(key5, RefKey3, RefKey4)

and I have a problem with the datatable editor for T5 (C#).
Actually I want 2 select options one for RefKey3, the other for RefKey4
but instead of a list of meaningless keys i want "field31, field32" for RefKey3 and "field11, field12, field21, field22"

Since there is no table that contains jointly "field11, field12, field21, field22" i tried a sotred procedure, but later i found that it is not supported. how can i render the editor column RefKey4 using two joins T1 for "field11, field12" and T2 for "field21, field22"

what should I have for the join model and what should i do at the apicontroller ?

Regards

DiabloRito

I did it using List<Dictionary<string, object>> for options.

Regards