Hi there,
I have the following Access-related problem.
Given a set of problems, which have several alternatives (possible
solutions) and criteria for these solutions, I need to give values for
these criteria. It comes down to four interrelated tables, for each
problem has several possible solutions, these all are judged by a set
of criteria (several for one problem, the same ones for each
alternative). And then for each criterium there are several values
(one for each alternative).
Now, wanting to create an input-form for the criterium-values, I need
to give the name of each problem, each alternative and each of the
criteria from the three other tables, and then save the input value
into a fourth table.
Building a form from a query which gives all those values, I can show
everything I want to - but then it is impossible to put in new values
and to save them.
If anyone looks through the above description, I would be more than
grateful for any advice or hint how to build a form that gives the
necessary information and then enables me to put in new values for
another table.
Of course, I will gladly give more information and answer any
questions.
Thanks a lot
C.
Bas Cost Budde - 09 Nov 2004 11:12 GMT
Can you apply subforms for the criteria?
C. Cleophas - 09 Nov 2004 12:29 GMT
The problem is that I would have to have two hierarchical subforms just
giving the information (one alternative-sub to problems, one
criteria-sub to alternatives), and then a third to put in the
information - access does not let me build up the necessary hierarchy
of form, sub-form, sub-sub-form and sub-sub-sub-form for input.
Or have I overlooked something?
Bas Cost Budde - 09 Nov 2004 13:01 GMT
> The problem is that I would have to have two hierarchical subforms just
> giving the information (one alternative-sub to problems, one
> criteria-sub to alternatives), and then a third to put in the
> information - access does not let me build up the necessary hierarchy
> of form, sub-form, sub-sub-form and sub-sub-sub-form for input.
> Or have I overlooked something?
As far as nesting subforms, no, that's the limit.
Let me come back to the original structure. I understand you want to
store values for criteria. That makes me think the form should be based
on the table for these values. What does the table look like? And how
exactly is the relation to the other information types?