non-updateable query with memo field

[Guest]

I have a query with inner join of two tables that contains the PKs of both
tables and should be updateable. I need to be able to update a memo field in
the query and cannot figure out why it's non-updateable.

Here is my SQL statement:

SELECT t.CodeTextID, t.PartyID, t.CodeID, t.Text1, a.CodeID AS ACodeID,
a.CodeTypeID, a.SortOrder
FROM CodeText AS t INNER JOIN CodeTypeAssociation AS a ON t.CodeID = a.CodeID
WHERE ((a.CodeTypeID)=42);

 

[Guest]

If the memo field is on the many side of the relationship, you won't be able
to update it.

Also do you have the relationship defined in the Relationship Window the
referiential integrity enabled? If you can't get RI to work, that could also
cause the query to be unupdateable.