Hi! I'm trying to figure out how to make this possible... What I have here is a company address, along with both the primary contact and secondary contact. In them is one email address from the primary contact and one other email address from the secondary contact. Problem is setting an unique primary key that treated the 2 columns as one column with unique email address.
Let's this example below --snip- | First_Email | Second_Email | ------------------------------------------------ | [EMAIL PROTECTED] | [EMAIL PROTECTED] | ----------------------------------------------- | [EMAIL PROTECTED] | [EMAIL PROTECTED] | ----------------------------------------------- --snip- be like this below where there is no two same email address.... --snip- --------------------------------------- | [EMAIL PROTECTED] | --------------------------------------- | [EMAIL PROTECTED] | --------------------------------------- | [EMAIL PROTECTED] | --------------------------------------- | [EMAIL PROTECTED] | --------------------------------------- --snip- Thanks, Scott