Listbox Question

[scott04]

Hi Everyone,
I have a listbox on a form that lists all our company locations. How can I
design the form so that it allows me to select muliple locations from the
listbox to store in my table? Is a list box not the way to go? Any help is
as always much appreciated.

 

[Klatuu]

Do you mean store multiple locations in the same field?
Not really a good idea.
Explain what it is you want to do and maybe we can help with a better
approach.

 

[scott04]

Dave,
I want the associate to be able to select from the form which location a job
may be needed at. In some cases the same job will be needed at multiple
locations. Are checkboxes the way to go?

 

[Klatuu]

no, check boxes would not ne a good idea.
You need to either have a record for each job/location combination or a
child record to you job record