Rather using portals to view the other data sources, you could create new layouts based on you other tables/data sources.
Create a various layouts for viewing respective data sources.
Attatch Goto Layout to your 'homepage' buttons to open new layouts.
Create exit buttons to these layouts to return you back to your 'homepage'.
Thanks for your reply, I already have this action but what I want to do is have some quick data in front of the user at the "switchboard" as opposed to going back and forth switching buttons.
Although you have given me an idea and maybe I could use a few different windows open each with its own layout displayed and then I would have these open and close with the "switchboard" screen.
I do think this will look a little messy though and I would prefer to have it all on one form.
OK I see what you are trying to achieve.
I am by no means an expert but there is a way to create relationships from a 'main' table (Switchboard I'm thinking) to all other tables by using a cartesian cross product.
From my understanding you create relationships using the primary key from your main table to the primary keys to all your other tables. Change the relationship between the main table and all your other tables to a x rather than = (double click the = sign to open the edit relationship dialog and select x from the dropdown in between the two tables that should display = as default)
All tables should now be related to the main table allowing you to use portals from these tables on your switchboard layout.
I haven't tested this but in theory should work
Maybe this link will help:
this works and I am getting data in the portal now, I just go to figure out how to play with it all.
Thanks for your input!