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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Multiple Value Search    
 
   
sajith354
post Oct 26 2017, 01:35 AM
Post#1



Posts: 5
Joined: 5-February 17



I'm not an expert in Access; but trying to develop a database search according to selected criteria. Database is attached.
I need to get details of employees attended training to Tbl_Training_Individual
from Employee Table (tbl_Emp) and training details table (Traing_Details). I've been struggling to solve the error, pls help.
Attached File(s)
Attached File  Sample.zip ( 63.38K )Number of downloads: 8
 
Go to the top of the page
 
Jeff B.
post Oct 26 2017, 07:17 AM
Post#2


UtterAccess VIP
Posts: 10,142
Joined: 30-April 10
From: Pacific NorthWet


What error, when/where does it happen?
Go to the top of the page
 
orange999
post Oct 26 2017, 07:22 AM
Post#3



Posts: 1,862
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


Please describe the business process(es) involved in plain English.
You may be missing some table(s) in your set up.
Go to the top of the page
 
sajith354
post Oct 27 2017, 02:27 AM
Post#4



Posts: 5
Joined: 5-February 17



Sorry for not elaborating my issues.
This is for employee training database; I need to search the database either any of the given criteria or combination of the same.
My doubt is how to set the Relationship when three tables are involved; i.e., Employee (tbl_Emp) data from one, Training details (Training_Details) from second and individual employee training details to be stored in (Tbl_Training_Details).
When I set Relation between the tbl_Emp (Emp_No) to Traning_Details (F_Emp_No); no result is displaying from Tbl_Emp fields.
Attached File(s)
Attached File  Capture.JPG ( 47.06K )Number of downloads: 3
 
Go to the top of the page
 
Jeff B.
post Oct 27 2017, 07:18 AM
Post#5


UtterAccess VIP
Posts: 10,142
Joined: 30-April 10
From: Pacific NorthWet


How do you, in your situation, differentiate between an employee and a training individual?
Go to the top of the page
 
sajith354
post Oct 27 2017, 11:31 PM
Post#6



Posts: 5
Joined: 5-February 17



Thank you Jeff, for your valuable time,
I understood that you are confused by the table name "Tbl_Training_Individual"; what I intended is that this table should get information of Emp_ID (Employee who attended ,i.e. from 1st table) and Training subject ID (from 2nd table) that he attended (TrngSub_ID).
In my situation, all employees are encouraged to attend maximum training; however, graded staff should attend certain mandatory Training.
Go to the top of the page
 
Jeff B.
post Oct 28 2017, 06:27 AM
Post#7


UtterAccess VIP
Posts: 10,142
Joined: 30-April 10
From: Pacific NorthWet


So, you're saying that some Training is mandatory (and I assume you need to ensure/verify that an Employee has attended), and other Training is urged but optional.

If Training X (?CPR training) is mandatory, is it mandatory for ALL Employees?
Go to the top of the page
 
sajith354
post Oct 28 2017, 10:59 PM
Post#8



Posts: 5
Joined: 5-February 17



There are three different category of staff; graded, non-graded and contractor. Only graded staff is required to attend mandatory training; others just need to attend any 10 (minimum) trainings.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd October 2018 - 02:26 PM