How To Create A Unique Index On A Composite Key

[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?

 

 

[Mathilda]

Hi,

As far as I know, composite keys are not supported in caspio yet, you may vote for this feature here

[ray]

Hello. Use javascript on the DataPage to concatenate the fields you want in your composite key and create a new field in the table to store the concatenated value. Set that table field to Unique and you should get an error when you try to save a record that duplicates the composite field.