Current problem deals with three tables in my database. The
"DOCUMENTSLIST" table has a one-to-many relationship to the
junction table (DOCUMENTS/PROJECTS) which, in turn, has a many-to-one
relationship to the "PROJECTS" table.
The tables have the following fields:
DOCUMENTSLIST DOCUMENTS/PROJECTS PROJECTS
Document ID (P key) Documents/Projects ID (P key) Project ID (P key)
Type Project ID (F key) Project Name
DID Number Document ID (F key) Project Type
Document Name Responsible Officer Organization
Required (Y/N box) Preliminary Date `Comments
----- Draft Date POCs ID (F Key)
----- Final Date -----
----- Comments -----
Structure of the primary form: The PROJECTS table drives the main form
and displays the project name, project type and organization. I then
want to use a documents tab on the primary form to display information
related to specific documents associated with the project. There are
many documents which would potentially apply to a given project and the
DOCUMENTSLIST table lists all possibilities. I have placed a command
button on the documents tab subform to pop-up a form listing all the
documents with a yes/no box beside each to allow a user to select those
documents that apply to the specific project. This form populates the
"Required" y/n box in the DOCUMENTSLIST table. This table is then
used to drive a "documents_selected" query to get the list of just
the applicable documents.
I plan to put a command button on this pop-up form to run a macro which
will:
A) update the DOCUMENTS/PROJECTS table with the documents selected.;
B) clear the checked boxes on the pop-up form so the next user has a
clean form to work with.
C) Close the pop-up document selection form.
The issue: How do I make the DOCUMENTS_SELECTED query update the
DOCUMENTS/PROJECTS table? Have looked through this newsgroup and
haven't found the answer that I think will let me do this. Any help
anyone can provide will be much appreciated.