P
Peter Kinsman
I have a table of Planned Production with a field for the Production Week
and a query which selects the records for a particular week. A second query
uses a 'Matched Records' link to obtain the Product Description . When I
use a datasheet to display the output from the second query, the Actual
Quantity field can be updated. So far so good, but the client wants to be
able to see ALL Products, rather than just those for which there is a
Planned Quantity, so I have to change the link to 'All Records from the
Product Master' and the resultant recordset cannot be updated. Does anyone
have any suggestions please. I have resorted to using a table rather than a
recordset, but it seems very untidy. I would expect similar problems with
Bill of Materials processing, but I have not been able to find any suitable
examples.
Many thanks
Peter Kinsman
and a query which selects the records for a particular week. A second query
uses a 'Matched Records' link to obtain the Product Description . When I
use a datasheet to display the output from the second query, the Actual
Quantity field can be updated. So far so good, but the client wants to be
able to see ALL Products, rather than just those for which there is a
Planned Quantity, so I have to change the link to 'All Records from the
Product Master' and the resultant recordset cannot be updated. Does anyone
have any suggestions please. I have resorted to using a table rather than a
recordset, but it seems very untidy. I would expect similar problems with
Bill of Materials processing, but I have not been able to find any suitable
examples.
Many thanks
Peter Kinsman