Re: Subform problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O6iUKmrnFHA.3656@xxxxxxxxxxxxxxxxxxxxxxx
> Hi, all;
>
> I am working on a database that allows you to enter data that will be used
> to power an e.learning course. Some of the pages in the course will have
> pages, and some won't. But each question, when it appears, will appear on
> only one page for now but may need to be reused in the future. Rather
than
> having columns for the question-specific information in ALL pages, I have
a
> separate questions table, and the Page table is related to it by the
> QuestionID. So in other words, some pages will have a null questionID if
> there is no question, and some will have a questionID.
>
> I have a page form set up with a Question subform. I was hoping that when
I
> changed to a new, blank page and created a new question, it would create a
> new question and automatically assign its QuestionID to the page field.
> However, what happened was that on the first page, it created a record
with
> a QuestionID of 0(!). On subsequent pages, edits on the Question subform
> are ignored, and when you return to the page you'll see just the one
> question referred to again.
>
> When I created the subform, I was prompted to define the exact
relationship
> between the tables, since it was parent to child rather than child to
> parent, but whatever I did apparently didn't tell Access exactly what I
> wanted from the form>subform relationship.
>
> What should I do to help Access figure out that it should create a new
> question when I fill in a blank question form and assign its ID to the
> parent form's QuestionID field?
>
> Thanks;
>
> Amy
>
>

The form/subform structure is specifically designed to reflect one-many
relationships, you really can't turn it upside down like this.

I would suggest that you have a "question" field on your Page form, as a
combo box or whatever is appropriate to enable a choice of existing
questions, and next to the "question" field you have a "New Question" button
that pops up a form which allows the entry of a new question.


.

Quantcast