database forms

[lloyd33]

I have created a contacts database. Table Employees contains records about contacts and employees they are distinguish by a field called type which contains the choice Employee Or Contact. I have a one to one relation which is a subset table called Contact which contains information only common to contacts. I also have a junction table which contains the Employee ID and ContactID so i know which Employee has created a new contact.
My problem is I do not know how to link the forms so that I can select an Employee and create a contact and the juction table is also updated with the correct link between employee and contact.

I have zipped my database can someone help please?

 

[lloyd33]

Contacts DB

Thanks for your help I have attached a screen shot of my relationships. Why u my ask? Because the relationship window shows that if I implement your suggestion then I have a one to one relationship and have no way of having an employee link to many contacts, or am i reading this relationship wrong.

 

[lloyd33]

db

Found out what I was doing wrong on the relationship screen do not worry. Thanks for your help