Hi guys,

I have two tables - 1 Album holds many Images. What I want is a a TypedList that has:

• albumid
• albumtitle
• imagecount

i.e 2, "holiday photos", 20

Is it possible to define a TypedList in the designer that will provide this info or will i have to create a dynamic typed list?

Cheers,

Pete

It is very possible. Define the typedlist between Album and Images. Add the AlbumId and AlbumTitle columns from Album to the typedlist. Then add the pk of the Images table to the typedlist and use count as the aggregate function.

Now when you fetch the typedlist be sure to add the two fields from the Album entity to a groupbycollection to be passed in the fetch call.

Hi brian,

thanks, that did the trick

cheers, pete