General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Josh,
I was able to reason it out later in the day, but thanks for your reply just the same.
Stan
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only