UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Automatically Copying Primary Key Into An Other Table, Access 2016    
 
   
manansafdar
post Feb 15 2020, 12:09 PM
Post#1



Posts: 14
Joined: 28-July 19



Hi!

Greetings,

I have a Database for HR Management, I have a "tblEmployees" with PK "EmployeeID".
Another table named "tbluSchools" has list of schools in which these employee work with PK "SchoolID".
I have a junction table named "tblschoolEmployees" in which "EmployeeID" is linked with "SchoolID".

I want that when I add an employee in tblEmployees it automatically get added into tblSchoolEmployees as well as I want to add the schoolID for this employee.

Any support will be much appreciated.

I have attached here the Database for reference.
[attachment=93169:HR_Management_V19.zip]
Thanks,

Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    4th July 2020 - 06:49 PM