Main Form Combo Box help needed

[nobbie1]

Hello one and all, I'm back with another problem that I'm not sure how to handle.

I've made up a database to help track work done by our technicians. I would like to be able to add to my main form a way of keeping track of work done by technicians if they are grouped up on a special project or task. Right now it's set up so that each technician enters in the work they did on which ever line. At some point in the future technicians will team up to do certain tasks and instead of having 2 techs enter in the same data I'd like to be able to track when a technician works with a partner. That way one person can enter in data and then if they worked with someone they're tied in with the work but don't have to enter it in twice. I'm not sure if I should have a combo box or List box on the main form that lists the technicians or if I should put it in the subform and track it from there.

I hope this is clear enough. I'm attaching my database as it is now in the hopes that someone can point me into the right direction. Or if my database won't support what I'm looking for, just let me know...I know how to take criticism.

Thanks in advance for any help

 

[WayneRyan]

nobbie,

You're right, the subform approach is the best. If you make a
new table for work perfomed, each tech can have an entry
consisting of time worked, status, etc.

The subform can have a combo to select the tech's name.

Wayne