Prev: numerical summation to passed from sub to main form
Next: Subform New Record
From: milwhcky via AccessMonster.com on 11 Mar 2010 15:27
Sorry I couldn't reply sooner, but I've been away from my desk...

My select query did not use DISTINCT or DISTINCTROW. Neither changing the
query to SELECT DISTINCTROW, nor changing the query's Recordset type to
Dynaset (Inconsistent Updates) led to a positive result.

Something did come to mind which may help someone steer me in the right
direction...

On my TrackingNumbers table, OrderID is one of two fields which make up the
primary key. The second field is LineNumber (autonumber), which is used
because many invoices have more than one tracking number. Therefore, the
same OrderID is listed more than once on the TrackingNumbers table. On the
Orders table, OrderID is the lone primary key field.

This was my first project using a table with a PK of more than one field, so
I wonder if this is the source of my hiccup.

Thanks to everyone who has attempted to help!

J_Goddard wrote:
>Hi -
>
>You haven't really done anything wrong; the problem is that the query itself
>is not updateable. Try using SELECT DISTINCTROW in the query SQL, end ensure
>that all your joins are FK to PK, or to a field with a unique index. That
>might make the query updateable.
>
>John
>
>>I have a continuous form based on a multi-table query.
>>
>[quoted text clipped - 27 lines]
>>
>>Any ideas of what I could have done wrong?
>

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

First  |  Prev  | 
Pages: 1 2
Prev: numerical summation to passed from sub to main form
Next: Subform New Record