General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>When using a view, if two records have the same values in all their key fields, and I change the value of any field in one of the records, the other record is changed and gets the same value in that field. Even further: if I try to delete one of the records, it results in both being deleted.
>
>Is there any way to have two repeated records in an updatable view and manage them individually?
>
>TIA.
You must have at least one unique field as your primary key, or a combination of fields marked as the primary key in your view that would amount to a unique value.
Example:
CD Name
Artist
Track
Title
Alone, these fields may not be unique, but together they would create a unique value.
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