Hello,
I found a second problem with queries, but this one affects also
standard queries.
I started with two tables with an inner join between their primary keys.
Then I built a simple query with a few fields chosen from both tables,
primary keys included. All worked well until I inserted two criterions
as filter under the same field (OR condition).
The query continue to work, but after closed and re-opened in Design
View, it's structure was changed: the graphical line representing the
relationship was missing and a new field was added to realize the same
relationship.
This way the query continue to work, but in Design View it appears
almost confusing for any further reading and modification. Please, note
that such a modification happens only with two or more criterion filter,
whilst with one criterion only all remain unchanged.
Please, tell me whether this is by design or I have to submit a new
issue. In case, I can send a little sample database.
Thanks in advance,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
