Multi Selection in Access

S

si1976

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.
 
K

KARL DEWEY

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.).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Data Entry Form. 3
Selecting a Value from a table in a form 6
new access user want to creat employee incident log 2
Automatically populate a field based on 2 others 7
Event in a form 1
Employee Shift Schedules 2
Entering Formulas in Access Forms 2

Top