Daar Users,
So I've create a number of projects in phpRunner. One of the biggest users is a company called ABCXYZ. For this company I've create a calendar/Job Scheduler, a database used in an Android app called GTS, A Contact database called CIMS and a Proposal Tracking System. These databases are all separate mySQL DBs and some databases residing on one domain and the others on a different domain but all residing on the same web server in mySQL databases.
What I want to do is link some of the tables in the databases so they can be used in all of the applications. For example each database and application has a table called tbl_Contacts and tbl_Clients. Now we have 4 copies of tbl_Contacts and tbl_Clients that need to be kept clean and in-sync. My thought process was to have only one tbl_Contacts and tbl_Clients that need to be updated and have all the other databases link to these tables.
In Access, which I'm the most comfortable with, I am able to do this using the LINKED TABLES function. Does phpRunner have anything like this function? Do you have any suggestions? All of these phpRunner applications were build using version 5.3 and will be upgraded to 6.0 if needed.
Thanks
DouglasB
