Add many to many relations with existing entires and search

[Roundtrip42]

Hello everybody,

so I have a table called "document" which stores various kinds of documents and a table "person" which stores information about people. One document can have many people in it and one person can occur in many documents. I have an additional table in my database called document_person to make this many to many connection.

What I want is to have a form, that shows a document (where i can click through all documents) and at the same time shows all person entities connected to the showing document. So far so good, because I managed to do that.


But what I cannot do is add exisiting entries from the "person" table to one document. I imagined some kind of button, and onclick it opens a popup where I can search for specific person entries and choose one or more entries and add them to the document.

Attached you can find my database design, but it is german.
I hope someone can help me with this

Cheers,

[ranman256]

make a form with a list box of persons, (person.id, VorName & nachname )
on the form is a combo box of documents.
user selects a document in the combo,
then dbl-clicks on a person, this fires an append query that adds the doc ID (id_dokument) and ID_person to the PERSON_DOKUMENT table.

insert into PERSON_DOKUMENT (ID_PERSON, ID_DOKUMENT) VALUES (forms!myform!lstPerson, forms!myForm!cboDoc)