Help with Form

[pleeson]

Hi all,

I am after some help with my form/database.

The attached file is a screenshot which may give a better idea of what I am trying to achieve.

Currently I have three tables that I have set up to solve this problem.

JOBS, CONTACTS, and JOBS_CONTACTS_LINK.

I have set up a query that pulls the contacts associated with each job which is shown at the bottom of the screen this also has a delete function I set up where I can tick and then delete a contact from a job.

This is where I am stuck:

How can I add a new contact from an existing pool of contacts.

My ideal way of doing this would be to open up another form, and from this form select the contacts required and then select an add selected button which will then add the selected contacts to that job.

All I need to do is to find a way of adding the ContactID and JobID to the Job_Contacts_Link Table for this to work.

There are a couple of other attachments showing the relationship and the query used.

Hope there is a way and the above makes sense as this is driving me bonkers

Thanks all

Paul