Control Panel. Please help!

[mgxdigital]

Hello!

My boss wants me to make new database to be his "control panel". He wants to be able to look at one screen and see what's going on with our jobs database, purchase order database, commissions database, etc.

[color:blue]Does anyone have any suggestions on how to start this?

I would assume that I would do everything through portals, but i'm not sure how to connect them all to this new database since it will essentially be blank.

:

Thanks so much!

Edited March 2, 2009 by Guest

[bcooney]

When you say "database" do you mean FM file? That is, are Jobs in one FM file and POs in a different completely unrelated FM file?

Relating a SYS table to all the other tables (files?) using cartesian joins might let you show all records from these tables in portals. But, the next step will be navigation scripts.