updating a junction table

G

Guest

I am using Access 2007. I have 3 tables: Questions,
Assessments and QuestionLocation table to show which questions
are on which assessments. The QuestionLocation table fields
include QuestionLocationID, QuestionID and AssessmentID as well
as a few others which are not relevant. I want a form that will
update the QuestionLocationTable without the user having to
memorize the QuestionID. I envisioned a simple form to scroll
through all the questions with a button on the bottom that
prompts you to fill out the additional fields need to add the
currently displayed question to the QuestionLocation table. I would like to
update from a Questions form because I would like the user to be able to
filter and/or sort questions and see all the Question fields before adding it
to an assessment.
 
A

Allen Browne

Unless you have many thousands of questions, you could use a combo box so
the user can choose the question.

The RowSource for the combo will be from your Questions table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying fields in a form based on a value stored in a table 2
How to make checkboxes add records to junction table 4
Store Multiple Values from Form into Table 3
parent, child, junction... 1
Multiselect in datasheet view? 3
Data Structure for Student Tracking? 3
Append records to table only if user selects "True" on form 2
Junction table record from a form 1

Top