I set up a table with a unique pt number which was indexed as no duplicates and made it the Primary key. I used the unique number in  a 2nd form and made it the primary key, no duplicates, and was told I had broken the integrity rules as this duplicated values?? Relationships lesson 7 time 0259

---

Reply from Richard Rost:

Don't make it a primary key in your second table.