This topic is locked

Multiple Links with Using Master-Detail

1/16/2006 6:56:22 PM
ASPRunnerPro General questions
pbunyon99 author

To Tech Supt:
I have two tables (Org Structure[M], Employees[D]) and want to join them 8 different ways (there are 8 levels in my organization structure).

I can get display my Org Structure[M], then click on Employees[D] to get the employees in a particular Org#. This is working great!

However, I want to join that Org Structure[M] by Org# to 7 other columns in the Employee[D] file that have that Org# in it. Each type of join would be a menu item on the main ASP Runner Menu.

I can't seem to do it with views, so I have resorted to 8 copies of my Employee table. When I use views in the Master-Detail setup screen, ASPRunner (v3.2) does not display any of the columns of the detail view.

Shouldn't ASP Runner be able to multiple Master-Detail views of the same two tables ??

Thanks.

Sergey Kornilov admin 1/17/2006

You can do this using Views in ASPRunnerPro 4.0.
Just create several views of Employees table and setup a master-details relationship for each.