Hello, I have a strange question. I'm in the design phase for a table and was wondering if it's possible in MySQL to force a pair of fields in a record to be unique within the table. I would like it to look like this:
user_id job_id What I'd like to do is never have the same user_id and job_id paired up paired together more than once. Maybe I'm missing a better way to setup this table. If I am, please let me know. Thanks. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. [EMAIL PROTECTED] | http://www.mrichi.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
