I have a join table with just the 2 id fields to link a master record to its detail records. For example, 1 Quote (tbl_quote) can have multiple Tags (tbl_tag) so the QuoteCategory table has quoteID and tagID.
I don't want to allow duplicate records in the QuoteCategory table. I only want to allow any Quote+Tag combination to be enter once. So how do I create a unique index on the combination of quoteID + tagID?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
bdrhoa
I have a join table with just the 2 id fields to link a master record to its detail records. For example, 1 Quote (tbl_quote) can have multiple Tags (tbl_tag) so the QuoteCategory table has quoteID and tagID.
I don't want to allow duplicate records in the QuoteCategory table. I only want to allow any Quote+Tag combination to be enter once. So how do I create a unique index on the combination of quoteID + tagID?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.