benallen002
Board Regular
- Joined
- Feb 16, 2005
- Messages
- 65
Hi all...after swimming around in the deep end of Excel for a while now, I'm just starting to get my feet wet with Access and had a question for the board. Forgive me if it seems elementary:
I have an Assignments table that stores Date, EmployeeID, ClassID, PayRate, Location, and a few other pieces of info per assignment. I have built a form for this table and what I would like to do is have the default values for anything related to the Employee (PayRate, ClassID, etc) assigned automatically when the user selects an Employee for the task. In other words, I have the employee's default information in the Employees table, and I want my form to look that information up for use as the Default Values when that Employee gets selected for an Assignment. That way if his default values don't change, the user doesn't have to enter them again everytime they are given a new Assignment.
I hope my explanation of the problem makes sense, and appreciate any help on the matter.
I have an Assignments table that stores Date, EmployeeID, ClassID, PayRate, Location, and a few other pieces of info per assignment. I have built a form for this table and what I would like to do is have the default values for anything related to the Employee (PayRate, ClassID, etc) assigned automatically when the user selects an Employee for the task. In other words, I have the employee's default information in the Employees table, and I want my form to look that information up for use as the Default Values when that Employee gets selected for an Assignment. That way if his default values don't change, the user doesn't have to enter them again everytime they are given a new Assignment.
I hope my explanation of the problem makes sense, and appreciate any help on the matter.