Hi,

If I have a middle table in an m:n relationship, and have loaded a number of records using the adapter templates.

Is there any way of filtering the list by one or more of the key values on the client side. I need to select only the entities with a specific property without round tripping to the database again.

What is the most efficient way of doing this?

Regards Craig.

How expensive is that connection with your database btw? You seem to try to build an in-memory RDBMS to avoid roundtripping to the database. However don't forget that client-side code can be slow compared to server-side code in the database, so it might not always be more efficient to do things client-side.