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.