Show all records in a portal
I have a layout that contains the jobs that my company does. We have about 3500 job records. I am wondering if it is possible to make a new database seperate from the jobs database but show the job records in a portal on the new database. All of hte jobs have distinctive job numbers.
The new database that I am trying to build is some what of a "control panel". My boss wants to be able to look at one screen and see what's going on on multiple layouts. And he wants this is a completely new database.
Is there anyone that can help me with this. I can put a job number field in the new database and tie it to the job number in the jobs database to connect them, but i'm not sure how to show all of hte records without having the new database draw from the jobs database.
I'm so lost!!
Any suggestions at all would be amazing!!!!
Thanks so much!