Form Building Problem

[cleophas]

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.

 

[Rebecca Riordan]

The rules for when Access can update a query dataset are somewhat complex,
but basically, you can update the fields in the "most-many" table. That is,
if you have combined tables A, B, and C, and there's one-to-many
relationships between A and B and between B and C, then Access will let you
update fields drawn from table C.

If I'm following your explanation, I think you've violated that -- do you
have a many to one between value and solution?

But I'm not at all sure I'm following you. Could you maybe give a concrete
example?

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress