Multi Join Depression

[simoncpage]

I have a multi join relationship

Three tables are

Asset (y/n)

Fund (y/n)

and then this multi join is related to a Company

What I want to be able to do is this and I'm getting so confused....

See attached..I want to be able to have a main company page that shows the four types with the definite yes and no. Then I want to be able to drill in to each one of these and see all the definite global yes and no related to that. For example

Global Def yes to Asset1, Fund1

Global Def No to Asset2. Fund2

Therefore the following when I go into Asset1 I should see a yes to Fund1 and a no to Fund2.

On top of this I would like to be able to add specifics for Asset1 like Fund3 which isn't global but only related to Asset1.

If anyone can push me in the right direction with this it would be most appreciated.

Fund_Asset_Copy_1.zip

Edited December 10, 2005 by Guest

[bruceR]

You're going to have to put some more effort into your explanation.