Access Forms

Hi all,

I am currently on the way to developing the office database but as a practice/series of tests I am taking certain elements and things that the office would want to do and trying them out before taking the plunge.

My Question.(there is an attachment which may help)

I have 3 tables CONTACT, JOBS, and Contact_Jobs_Link (this holds JobID and ConID) I have then created the relationship and query making an inner join.

Next step was to create the form in which I have JOBS and then the query as a sub form showing which contacts relate to the job shown.

What I would like to be able to do is to add an add contact to job button which will then bring up a searchable list. It would then be nice to be able to select each contact to add via a checkbox maybe and once an add button on that form is selected it adds the those contact ids to the job number in Contact_Jobs_Link table.

Does anyone know if this is possible or better still have an example of how it could be done?

Thanks all, hope that makes sense.

Paul

I managed to sort this one out by using the OpenArgs Statement to bring accross the JOB_ID.

Then by using a couple of SQL statements inserting the checked contacts into the link table.

Cheers

Paul