>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 ;)

You should have a unique id on each table. Makes life a lot easier. Just have a function that generates them by incrementing a value in your "ids" table. See the VFP help for this.

>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?

It is easier to think of it as a 1-many in one direction, then as a 1 to many in the other direction (as two separate relations).