Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views without a unique key field
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00247410
Message ID:
00247452
Views:
25
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.

>Is there a way to create a view without a unique field as the key?
>I have an application where students may take the same set of tests and the only key would be the student number + the test ID. Can I use a concatenated key in a view or do I have to have a single unique field? Thanks for any assistance.
>
>Stan Symons
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform