Help with Summarised Data in Updateable forms.

J

John Ortt

Hi Everyone,

I have two tables which I have tried to represent below

Part Quantity Part Desc Comments
X 5 X Bolt
X 11 Y Washer
Y 4 Z Nut

I would like to combine the two tables on a single form to give all the data
in the second table and a sumarised Quantity from the first table. I would
like the users to be able to add comments based on the summarised quantities
but all the other fields can be non-updatable.

All the ways I can think of it result in a non-updateable query except for
using a sub-query but then I can't use continuous forms.

Any suggestions gratefully recieved.

Thankyou,

John Ortt
 
Top