Updating Table that has more than one Primary Key
When designing databases there is the chance that you will not always have one PRIMARY KEY on a table
For example
ISPEC_TABLE
PRIMARY KEY ISPEC_Customer SSI10 SSI10
PRIMARY KEY ISPEC_Part A1 B1
PRIMARY KEY ISPEC_Date 01/01/01 01/01/01
ISPEC_Comments
So when trying to update this record in Dreamweaver i am finding it hard - because i don't have a unique key column because i only want to update The Part B1 Comments
So i need to pass in all three primary key to the Update
Comments
Be the first to write a comment
You must me logged in to write a comment.