Unupdated queries

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have below query but it is not updateable by entering or editing data in
the query. Can someone advise how to modify it to be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30 AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray
 
Laurie,

Thanks for your sound theories.

Could you please give me some live examples to strengthen my understanding.
For example, I have a order processing table which contains some milestones
of the processes. The common links would be supplier information and
product information. If we need to link supplier information and product
information with the master table of order processing. What the join
properties and prior keys should be on each link and tables. Your further
advice is highly appreciated.

Ray


Laurie Eaton said:
Hi,
I don't pretend to be an expert on this Ray, but this is what I think.

If you JOIN on unique keys then Access will let you update the records.
Click to expand...
(I think the term is 'referential integrity'.) If the keys are not unique,
what is Access to do? - it can't write to multiple fields, hence the records
are not updateable. Well, thats where I would start. Let me know if I can
help more.
regards - Laurie Eaton

Ray said:
I have below query but it is not updateable by entering or editing data in
the query. Can someone advise how to modify it to be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30 AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray
Click to expand...
Click to expand...
 
Back
Top