In Acc2010 we are experiencing this error with a simple one-to-many updatable query, with the following message:
The query is wrongly attempting to add a new row to the 'one' table when it adds a new row to the 'many' table.
KB928023 acknowledges this as an Acc2007 problem. It says the problem arises if the output list includes a 'complex' field (sic) from the one table. Our output list includes only one field from the one table: a non-complex long integer ID field, with 'Allow Multiple Values' set to False (and no other properties that might make this a 'complex' field).
Have any other forum members seen this behaviour? Is there a solution? (We need the field from the one table to be able to filter by that field.)
The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.
The query is wrongly attempting to add a new row to the 'one' table when it adds a new row to the 'many' table.
KB928023 acknowledges this as an Acc2007 problem. It says the problem arises if the output list includes a 'complex' field (sic) from the one table. Our output list includes only one field from the one table: a non-complex long integer ID field, with 'Allow Multiple Values' set to False (and no other properties that might make this a 'complex' field).
Have any other forum members seen this behaviour? Is there a solution? (We need the field from the one table to be able to filter by that field.)