Hi..

I need some help with the following scenario.

I have two tables:

Member: MemberId (PK) FirstName LastName

Order: OrderId (PK) Identity MemberId (FK) Total

What i want is to get data of Members and their Last Order.. basically a MAX on the OrderId

I am using Adapter templates, LLBLGenPro v2.5, .NET 3.5 and SQL Server 2005

I recommend you to use DynamicList, DynamicList is bassically a datatable that you can fetch easily with LLBLGenPro filters, groupers, sorters, etc. If you want to use Entity objects, you could use one of these alternatives.