 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Multi Selection in Access
I'm trying to design a work order form that would contain a field that I can assign employees to the work order. On any given work order I could have from 1 employee to 30 employees....I don't want to enter the same information for every employee....is there a way that I can select multiple employees in that field? I would like to eventually be able to query by employee.....I would also like to be able to print a report that will show me every employee that was on that job? Thanks for your help. I would suggest using a one-tomany relationship between workorder table and workorder-employee table. Use a form/subform for workorder/workorder-employee. Then you can also enter start, end, hours, labor type (welder, inspector, typist, proofreader, etc.).  SignatureKARL DEWEY Build a little - Test a little > I'm trying to design a work order form that would contain a field that > I can assign employees to the work order. On any given work order I [quoted text clipped - 4 lines] > a report that will show me every employee that was on that job? > Thanks for your help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.