subform displays only one record :(

[silentwolf]

Hi again! I know it has been discussed on the net but I can still not get it to work.
I have a searchform with many different typ of txt boxes to filter a subform wich is based on a qyr_ContactAll
The subform property is set to datasheet few and when I apply a flter it shows me how many records it has found. All good!
But for some reason I can not get all records to show on the datasheet few of my subform.
Where can be the problem?
Would be nice if someone can tell me what needs to be changed in order to make this work.

 

[Norie]

Well maybe I was making some sense after all.

I hope you understand what I'm suggesting here.

You should have a table for customers, and a table for projects.

I suppose you could have another table for addresses for the projects but it would probably be better to just have the address in the project table.

Note, that doesn't mean you have to have an address for each project.

I don't have any sample data to work with but I'll try and mock the tables and relationships up.

Hopefully that will explain things better.