How to make this query Form Editable?

[lotharious]

SELECT InvProductOrders.PO, InvProductOrders.Item, InvProductOrders.SupplierID, InvProductOrders.Quantity, InvProductOrders.OrderPO, InvProductOrders.OrderDate, InvProductOrders.DateRecv, InvProductOrders.WhoRecv, InvProductOrders.AmtRecv, InvMaterials.ItemDesc, InvProductOrders.Comment

FROM InvProductOrders INNER JOIN InvMaterials ON InvProductOrders.Item = InvMaterials.Item

ORDER BY InvMaterials.ItemDesc;

I can make this query editable by changing it to inconsistant updates however when the form this query is designed for will not allow me to edit it.

Im wondering if this is because Item is the Primary key for InvProductOrders, and its a secondary/foriegn key for Item and can contain duplicates (at this point).

 

[jebry]

Hi!

What is the primary key for InvMaterials? Usually for a one-many link to be updatable in a query the select statement needs to include the primary key from the many table.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[lotharious]

Its actually a 1-1 relationship, just at this point there are some NULL entries in the ITEM field. I need to be going through and changing this as is.

The primary key for InvProductORders is Item, and the primary key is just a recID for InvMaterials.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lotharious]

Thanks PHV... learned a couple things..

Made the ITEM field uniq and indexed it as such, and form is now editable.