Hello Access Team!
Have a problem I am running into. Here is the situation:
Tables created=
- [EmployeeTable] which has ID, Last, First "All seperate Columns"
- [EmployeePositionTable] which has ID, Last, First, PositionName, PositionCode, PositionRequirements 'All seperate Columns'
- [RefernceTablePositions] which has PositionName, PositionCode, PositionRequirements 'All seperate Columns'
Queries Created=
- [AppendLastFirstToEmployeePositionTable] which has ID, Last, First 'Creating a One-To-One Relationship' New Employees added to [EmployeeTable] will be appended to [EmployeePositionTable]
Forms Created=
- [EmployeePostionForm] 'This form is a split Form. ID, Last, First are locked and cant be changed.
Here is the problem: In the form view under PostionName I would like it to be a dropdown box "LookUp" to select a postion based on the referance table. Once the selection is made, I would like PoistionCode and PositionRequirements to autopopluate on the form which sets the column value for that table.
Attached is my example database to work out the bugs prior to implimenting into my operational database.
Thank
autoPopfields.zip