>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

Let me phrase it my way and see if we're both saying the same thing, ignoring the large data set for the moment:

You don't want to have the user add a new record without first checking if the info already exists. If the data doesn't already exist it can be added.

What do you mean by key control? Is this is the current index of your data?
Is a leading search an incremental search thru the list tab grid of currently existing info?