Steve said:
I have made a select query drawing information from six different
tables all syncronizing data from the order ID, I have made forms
based on the query results and now I cannot edit the information in
the forms or the queries directly.
Steve
Thank you for any help
Read the help topic "When can I edit data in a query?"
There are many things that can render the results of a query non-editable and
having it include mutliple tables is one that "can" cause it. It's not an
absolute, but the structure of the query has to be "just right" for a
multi-table query to be editable and the more tables you add the harder it is to
maintain that ability.
Basically as you add more tables, it become increasingly difficult for the
database engine to know which tables to apply the updates to. Once an
"ambiguity threshold" is exceeded the query is made read-only as a means to
avoid data integrity problems.
Access/Jet is just about the most forgiving database in this area. Many engines
will absolutely not allow edits if a query/view has even two tables in it.
