Help Plz...

[Nad]

Hi Guys,
Two tables Employee and EmpServices.
Fields of Employee tables : EmpID, EmpName, Site
Fields of EmpServices : Site, EmpName, EmpID,ServiceType,Date,…etc.
Now I have a form (record source: TblEmpService) with fields Site, EmpName,
EmpID..etc. The Site field is a combo box with name say A,B,C,D etc. I also
kept EmpName as com boBox.
Question:
If I select any Site Name the related employee name should come in the
EmpName combo box list as every site has different employee. Also related
EmpID should also come in the EmpID text box.
Please help me to solve it.
Thanks & Regards

 

[Gina Whipp]

Nad,

Perhaps what you are looking for is...

http://www.fontstuff.com/access/acctut10.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Guys,
Two tables Employee and EmpServices.
Fields of Employee tables : EmpID, EmpName, Site
Fields of EmpServices : Site, EmpName, EmpID,ServiceType,Date,.etc.
Now I have a form (record source: TblEmpService) with fields Site, EmpName,
EmpID..etc. The Site field is a combo box with name say A,B,C,D etc. I also
kept EmpName as com boBox.
Question:
If I select any Site Name the related employee name should come in the
EmpName combo box list as every site has different employee. Also related
EmpID should also come in the EmpID text box.
Please help me to solve it.
Thanks & Regards

 

[Steve]

Hi Nad,

To begin, you need to revise your tables. They should look like:

TblEmployee
EmployeeID
FirstName
MI
LastName

TblSite
SiteID
Site

TblServiceType
ServiceTypeID
ServiceType

TblEmployeeOnSite
EmployeeOnSiteID
SiteID
EmployeeID
ServiceTypeID
StartDate
EndDate

To display a list of employees and their service type on a selected site,
you need ....
1. a query based on TblEmployee, TblServiceType and TblEmployeeOnSite.
From TblEmployee concatenate FirstName, MI and LastName to get the employee
name. From TblServiceType pull down ServiceType. From TblEmployeeOnSite,
pull down SiteID, StartDate and EndDate.

2. a form/subform. The main form should be based on TblSite. Use a
texybox to display the SiteName. The subform should be based on the above
query. Make the subform a continuous form. Set the LinkMaster and Linkchild
properties to SiteID.

Now you can use the navigation buttons to go to a selected site and the
subform will display a list of employees at the selected site.

If you need help setting this up, I can help you. I provide help with
Access, Excel and Word applications for a small fee. My fee to help you
would be very modest! Contact me if you want help.

Steve
(e-mail address removed)

 

[John... Visio MVP]

If you need help setting this up, I can help you. I provide help with
Access, Excel and Word applications for a small fee. My fee to help you
would be very modest! Contact me if you want help.

Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

 

[De Jager]

Hi Guys,
Two tables Employee and EmpServices.
Fields of Employee tables : EmpID, EmpName, Site
Fields of EmpServices : Site, EmpName, EmpID,ServiceType,Date,…etc.
Now I have a form (record source: TblEmpService) with fields Site,
EmpName,
EmpID..etc. The Site field is a combo box with name say A,B,C,D etc. I
also
kept EmpName as com boBox.
Question:
If I select any Site Name the related employee name should come in the
EmpName combo box list as every site has different employee. Also related
EmpID should also come in the EmpID text box.
Please help me to solve it.
Thanks & Regards