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
 
 
Start new topic
Replies
theDBguy
post Feb 15 2020, 12:51 PM
Post#2


UA Moderator
Posts: 78,476
Joined: 19-June 07
From: SunnySandyEggo


Hi. Welcome to UtterAccess! welcome2UA.gif

After looking at your forms, I don't see any need to do this. Your school assignment form include a list of employees to select. So, after you add an employee and want to assign them a school, they should be available from the selections anyway. Unless, did you want all new employees to be assigned a "default" school automatically?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
manansafdar
post Feb 15 2020, 01:06 PM
Post#3



Posts: 14
Joined: 28-July 19



So, after you add an employee and want to assign them a school, they should be available from the selections anyway.

No, they are not availabe for selection.
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    9th July 2020 - 03:41 AM