Hello Everyone,
I have 2 databases:Employee DB & Stat DB. I am trying to see if there is anyway I can have access "read" the Employee name in the stats database and "look up" the corresponding employee id from the Employee DB and bring it over to the Stats DB and have it function as a primary key in all my tables in the Stat database.
So in essence: the employee db has emp id, employee name, function, and the stat database has multiiple tables with their names and stats. I want to bring over the employee id to each table in the stats database so i can start linking up and performing calculations in the stats database.
any help would be greatly appreciated.