Hi,

Say I have a category entity which has a 'parentID' field which references another category, I want to add the parent's name to the category entity. What is the best way to do this?

If I map a field to a related field then that means doing a prefetch to retrieve the whole of the related entity. I just want to be able to retrieve the name value using a join rather than a sub query.

Is this possible?

Cheer, I.

You can create a typedlist, use a view, or define your own code to fill the field in a usercode region if you would rather just have the item available for the entity.

Do you mean a dynamic list?

Oh yes, the TypedList works great. Thanks.