March 2, 200916 yr 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, 200916 yr by Guest
March 5, 200916 yr 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.
Create an account or sign in to comment