So, I can not use the Database Designer because I "have" to use a Regular Index instead of Primary or Candidate Index? I need the DUPE records in both tables. I was told to NEVER, NEVER, NEVER use Unique Index ;) Oh oh oh, I realize something now, I think I need many-to-many relationship, I see. I have never used that so I dont know how that works. Can sxomeone shed light on many-to-many relationships?
Today is tomorrow's yesterday.