Hi,
I've a query which I run with absolutely no filter. And I don't get all the records. Why?
The query is data source to a subform in a form.
It consists of fields from several tables, which all are connected with one-to-many relations.
Does anyone have any idea why I don't get all records? I can't see any odd things with these records.
The intention is, which I also do, to filter this query from a combobox.
When I picked a specific value (a customer) in the combobox I saw that I didn't get any records in the subform, and now I don't know if I can trust the result.
Rgds,
HHAG
I've a query which I run with absolutely no filter. And I don't get all the records. Why?
The query is data source to a subform in a form.
It consists of fields from several tables, which all are connected with one-to-many relations.
Does anyone have any idea why I don't get all records? I can't see any odd things with these records.
The intention is, which I also do, to filter this query from a combobox.
When I picked a specific value (a customer) in the combobox I saw that I didn't get any records in the subform, and now I don't know if I can trust the result.
Rgds,
HHAG