Creating Lookup Forms From Field

[mveda2004]

Hello Everyone,

I am pretty new to access so step by step instructions would be appreciated. Here's what I am trying to do:



Goal: I need to have a form that has a drop down menu selection of Team Leaders. Once a Team Leader is selected, the employees related to that Team Leader should show up in another list / combo box and users can select that employee. When Team Leader and employee are selected and users hit the submit button, employee stats should populate.

Here are the tables I have in this database:

tblEmployees: pK: ID (auto number), EmpNo, FName, LName, FullName
tblTL: pK: TLID (auto number) , TL
tblFunction: pK: FID (auto number), Function (Department)
tblRelated: pK: ID (auto number), EmpNo, TLID, FID
tblCodes: pK: CodeID(auto), Codes, ( These are different types of absences an employee can have. ex: ovrper, late, vac, sick,... there are about 15 of them)
tblLeave: pK: ID(auto), EmpNo, LeaveAmount, LeaveDate


I have created a master query which brings all the information from these different tables together and that works fine. From here now I need to know how to create the form I mentioned above.

Thanks

[orange]

What you are describing can be accomplished by Cascading Combo boxes.
see these free video tutorials:
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Instead of tblCodes, you might consider tblLeaveCodes or tblLeaveTypes

In tblLeave I think you will want a fk for CodeId (I would call it LeaveTypeId, but it's your database).

It's refreshing to NOT see spaces in field names!!!

I don't think you need lookup forms as such, some combo boxes (controls) would seem to fit your needs.

Good luck with your project.