Form issue giving me a headache

[wildcat]

G'Day:

I have a form based on a table - tblAssignments
WorkerID
JobID
LocationID

from that form, there are combo boxes that allow me to select a person and then select their job.

What I need is after that person has been selected, I need to update another table - tblWorker to include the LocationID.

I know I need to us an AfterUpdate event, but I am unsure as to how to "look up" the WorkerID in the tblWorker so that it will updated the LocationID.

I hope this is understandable.

 

[boblarson]

If you are storing the LocationID in tblAssignments you should not be storing it in another table as well. That violates the rules of normalization and gives you redundant data. Why do you feel you need to store it in another table as well?

 

[wildcat]

The reason for the double storing is twofold:
1. I wanted to use that information to create an "unassignedWorker list"
2. to try and keep from having to redo other work that was created before I started working on this project.