Need Unique key to be multiple columns

Scriptcase 9 General
#1

I have a temporary table I build during an event.
I need to have the unique field be the combination of 2 separate fields. I tried to do this in the Creation of the table using Database Builder but don’t see how.

I see there is a way to do it if the table is the main table in the app.

anyone know how? (one of the fields is the AI index)

#2

I had recently a similar issue where adminer reports having created the primary key, but actually didn’t. I used DBeaver to set the database up. If you create the table dynamically by sql, then you can set it up correctly as well.