>Stan,
>
>You can use multiple fields as the key as long as the combination of the fields that make up your key is unique. In the view designer just check both of the fields as keys. If you're creating the view in code you can set the KeyFields property to more than one field by setting it to a comma delimited list of fields.
>
Minor correction: there is not KeyFields proprety for views. The property "KeyField" is tied to the field itself, so if you want multiple key fields, you would have to set it for each one.
Erik Moore
Clientelligence