Hi,

I've created 2 simple entities and "linked" them with a foreign key. I have also created a view showing the basic attributes of entity1, but also the foreign key info from entity2.

The results of my view below seems to ignore the foregin key... how can I create a view which will show the linked entity based on the foreign key? I don't want to perform another lookup based on the id of FundModelType just to get the description.

Here's my example with the results... hope this makes sense.

Entity1: Fund
Id
Name
FundModelType (linked with foreign key below)

Entity2: FundModelType
Id (foreign key)
Description

View1: Browse_Fund_Items
Fund/Id
Fund/Name
Fund/FundModelType
FundModelType/Description

Funds:
1, Fund1, [3]
2, Fund2, [1]
3, Fund3, [2]
4, Fund4, [1]

FundModelTypes:
1, Type1
2, Type2
3, Type3

The results of viewSearch:
1, Fund1, [1], Type1 - this record shouldn't show
1, Fund1, [2], Type2 - this record shouldn't show
1, Fund1, [3], Type3
2, Fund2, [1], Type1
2, Fund2, [2], Type2 - this record shouldn't show
2, Fund2, [3], Type3 - this record shouldn't show
3, Fund2, [1], Type1 - this record shouldn't show
3, Fund3, [2], Type2
3, Fund3, [3], Type3 - this record shouldn't show
4, Fund4, [1], Type1
4, Fund4, [2], Type2 - this record shouldn't show
4, Fund4, [3], Type3 - this record shouldn't show

Any help would be greatly appreciated.

Thanks and regards,
Jean