Multi Table Queries

[emmaweller]

I need to create a query that I can use in a form to add data to.
At the moment I can get the query to run but it will not allow me to amend or add data.
The query is made up of several table and are links with unique number ID.

Am I being to ambitious or have I missed a step out in creating my query.

 

[dakcg]

If you are trying to use too many tables at once to query, that could cause a problem. You should try to break it down to different queries. Use one query to get some info out of a couple of tables, and another to get some info out of the other tables. Then take those queries,and try to get all the info by joining one field the queries have in common.

Just a thought, dak

 

[Pat Hartman]

Read the article in help on updateable queries and search the archives here and in the knowledge base. Access tries to make all queries updateable. These articles will tell you what you have done to prevent this. If you can't work it out, post the SQL for your query and describe the table relationships to us.