hello,

thanks for last answer, i have one more:

i will use the adapter model and have tables with a lot of keys pointing to lookup tables ( e.g. article.categorie -> category.description). is there a way to read them all into a single entity like using a view with a lot of left joins?

i find it great to work an an entity collection, because its quit simple to show the data in a form or a grid, to validate them centrally and post them back to the database, but for readablity its sometime nessecary to supply thes additional lookup-infos.

thanks, kr dieter

You could do the following to achieve what you want, I think,

TypedLists, TypedViews, Custom Typed Lists / Views, or Prefetch Paths.