Composite Primary Key

[toddbanister]

How do you create a composite primary key for two columns for an existing table (with lots of data)? I am extending an existing SQLite db and wanted to define composite keys and add in some relationships if possible.

I must be missing something here fairly obvious. I tried to select multiple fields and make them a primary key but that doesn't work. Can someone please point me in the right direction?

Also, I am on a Mac if that makes any difference in the process.

Thanks
TB

[toddbanister]

Never mind - I figured it out. I completely missed the small row of icons below the column list on the table.