not all the records are shown by some queries.

Copper Contributor


Some records in a table are not shown by some queries. But not all the queries have this problem. What can be the problem. Is there a property wrong installed?

2 Replies
Give us a detailed example, along the lines of:
my table has a field with number - long integer data type, not required.
my query is "..."
The value "..." is in the table, but it is not being returned.
If you can post a sample database (one table, a few rows, one query) that demonstrates the problem, that would be even better.
Dear Tom,
Thanks for your mail.
The problem is solved, the maintable was wrongly fill out in some records for the relation with a subtable. The input is constrained now.