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    
post Feb 15 2020, 12:09 PM

Posts: 14
Joined: 28-July 19



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.

Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    11th July 2020 - 01:21 PM