You're correct. Users only work with a subset of all records, whether that be one records or something like "all customers in London".

If you change your current applications to work this way, users will need to change their way of thinking, but in my experience, users prefer the smaller set of records anyway.

>Thanks - this seems like a better approach than loading up all the records - I guess mostly users will only be working with one record and if they want a list view of the records they can be loaded then...