present read-only query within form

[HK]

Hello,

I am new to access/sql-developement and have the follwing problem:

What I finally want, is to present within a form the results of a query,
that are probably read-only PLUS a field WITHIN each record to store
extra data entered by the user. The problem is, that the query outputs a
read-only dynaset, so that my extra-Field is also - read-only.

I think, I have to define my query to produce read-only data, because I
have to use a "group". Do I? My query has to select all records from
table A an the sum of Field "Amount" of all records from table B that
"correspond" to the ID-Field of table A:

"SELECT Rohstoffe.RohstoffNummer, Sum(Lagerbestandsbewegungen.Menge) AS
[Summe von Menge]
FROM Rohstoffe INNER JOIN Lagerbestandsbewegungen ON
Rohstoffe.RohstoffNr = Lagerbestandsbewegungen.RohstoffNr
GROUP BY Rohstoffe.RohstoffNummer;"

I thought about writing VBA-code around the form, that stores my extra
data in an array that is updated internally. But this would be a rather
difficult solution.

Now I hope, I am talking about a standard-problem and someone out there
knows a standard-solution...

Holger.