Can anyone tell me why this query based on two local tables isn't editable? I made sure the fields were the same data type, indexed, etc. and I can't think of one reason this isn't updateable, but I really need to use the rs.edit method in my code on this recordset. I tried to assign the relationship in the relationships area first, but it listed the relationship as "indeterminate". It should be a many to many relationship. For example, the Data table has one record for each line item for each month for each calculation type, whereas the formula component table has multiple records per line item per calc type (but does not have a different record for each month).