applying filters in 1:n relationship tables???

Hi experts,



I have a table 'Investor' with two 1:n relations.

'Branche' and 'Contact 'person'.



How can I make a form in which I can filter the database for all



'Investors' that invest in 1 specific 'Branche'. I need the result to be



either as a columnar form (where I would see the data from the 'n' tables



as well).



The standard MS Access form-filter (applied on a on a columnar form)does



not search through all the data in the subforms('n') only on the current



screen.

So how can I search then through the 'n' tables and as a result get a



columnar form where only the filtered 'Investors' are?



I tried to do it through a querry where all 3 tables are selected and a



filter would be applied on this querry directly. It shows the correct



result, but the result is a Cartesian Product, where it shows the 1



investor many times corespondent to all the data in the 'n'-tables.



While using the Grouping function for the 'Investor' table and a



FirstValue in the 'n' fields. The Filter searches obviously only the



grouped values not all the 'n' values behind it(not all the Branches, but



only the first one displayed).



Please is there sombody that could tell me how to solve this, my



problem??



concluded: A search/filter where I can search the '1'(Investor) fields as



well as the 'n' fileds and finaly get a nice output that shows me the



Investors one by one(as a columnar form) or as a querry but only on



record per Primary Key(no cartesian product).



Thank you all very very much if someby finds it time to read my mesage



and help me.



thanks one more time..

Michael. (student) (answer english, german or czech)

Sounds like you need to investigate inner and outer joins.



Try a search on google as my explanation wont make much sense.

(open the relationship window in access and right click on the lines joining your tables)