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)