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