One to one relationships..
Using some of the examples on this site, I've created a many to many relationship using a junction table.. It works very well.
One of the tables (tbl_PersonInfo) contains person info (PersID (PK), PersName etc)
One table contains departments (tbl_Departments) that...