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: 4
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: 6
 
Go to the top of the page
 
Jeff B.
post Oct 26 2017, 07:17 AM
Post#2


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


What error, when/where does it happen?

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
orange999
post Oct 26 2017, 07:22 AM
Post#3



Posts: 1,715
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.

--------------------
Good luck with your project!
Go to the top of the page
 
sajith354
post Oct 27 2017, 02:27 AM
Post#4



Posts: 4
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: 9,886
Joined: 30-April 10
From: Pacific NorthWet


How do you, in your situation, differentiate between an employee and a training individual?

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
sajith354
post Oct 27 2017, 11:31 PM
Post#6



Posts: 4
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: 9,886
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?

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
sajith354
post Oct 28 2017, 10:59 PM
Post#8



Posts: 4
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    18th December 2017 - 09:52 AM