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

 

 

 

Reply via email to