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