How do you guys handle large data sets within the framework? If I have a 100,000 record SQL table that I want to add a new record to, typically I would want the user to "find" something that closely matches first, then allow an add. This helps to elimate typo mistakes when adding a record.

With this in mind, from the key control, I could also let the user do a leading search to see similiar records, then add if they see nothing to edit.

Hopefully I'm making sense. Has anyone run into similiar situations? Does the Framework handle this natively?

Thanks,

Chuck