I've thought about this one too and was curious what the general approach was. I've thought about taking it one step further and on the 'List Tab' having the SQL result return a table that is a result of multiple joins so the columns the user sees make sense instead of just an ID. Then when they go to the 'Property Tab' get the full record with a GetById type method call.

I was going to try and create two tables inside my dataset and setup a relation by the Primary key.

Anyone else do something similiar to this?

Thank you,

Bill