Recordset is not updateable 1

[ck1999]

I am getting this message when trying to edit a record in a form. The SQL is

SELECT a.FormulaName, a.SpecificGravity, a.NoShow, a.FormulaNumber, a.Revision, a.relabel, a.pails, a.Powder, a.New, a.Promotional, a.[5000], a.Specialty, a.Specmark, e.Description
FROM tblproduct AS a LEFT JOIN tblpricelist AS e ON a.FormulaName = e.ProductName;

The tables have a relationship however it says indeterminate and not one - to -one. And I do not know how to change the type I have deleted the relationship and tried to create a new one however it still says indeterminate.

I have tried a this link:

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

And have not had any success.
Does anyone have an Idea. The form properites allows edits.

Chris

 

[PHV]

Add the tblpricelist's PrimaryKey in the SELECT clause.

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

 

[ck1999]

Now I am getting an error "Can't enter value into blank field on 'one' side of outer join.

 

[ck1999]

Thanks PHV for the advice. That fixed the form