Query problems

[Phil]

I have a query that works just the way I want it to, however when I add
another field from another table to limit the data displayed, I cannot edit
any of the data in the query.

The new field is only there to limit the results, it isn't even displayed,
is there anyway I can limit the information using this field but still be
able to edit data in the query?


Any help would be great

 

[Guest]

Editing data through queries is limited. I found this information through
Google:

You cannot update a query that is based on three or more tables containing
many-to-one-to-many relationships.

You cannot edit the data in a crosstab query, certain SQL pass-through
queries, a query whose unique value property is set to Yes, a query including
linked ODBC tables, or a paradox table without a primary key.

Hope this helps.

 

[Guest]

Try using the second table as criteria and not joined. I think you would
have a criteria for the field you would normally join and and another for the
field you are using to limit the data.

 

[Phil]

It is a select query which only consists of 2 tables, the unique property is
set to no. I'm unsure about the other examples here.. what exactly is a
paradox table?


Cheers