Hi guys,
I would like to know how to link a database that has a table which gets updated automatically and regularly to a new database in a new table such that this new table also gets updated.
For example i have a database that records the login and logout details of an employee and but this database has to be not altered so i need to create a new database which should be linked to the existing database and such that the table gets populated with the data that is being collected by the existing database so that i can calculate the login hours of an employee.