Selecting more then one item in a lookup field.

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I am setting up a database for a company that puts on courses for lawyers.
We have a field to identify practice area but some courses fall under more
than one practice area. Is there a way to select more then one item in a
drop down field.
 
Sara said:
I am setting up a database for a company that puts on courses for lawyers.
We have a field to identify practice area but some courses fall under more
than one practice area. Is there a way to select more then one item in a
drop down field.
Click to expand...

No, but since what you have there is a one-to-many relationship, what you
could have is a sub-form on your form to contain the combo box so that you
can choose as many areas as you like. You *are* using forms, right? :-)

Keith.
www.keithwilby.co.uk
 
Sara

You might be able to use a "multi-select" approach, but I'm with Keith ...
it sounds like you have a one-to-many relationship. There are other
approaches that can help in that instance.

If you stick with a multi-select approach, be aware that you'll need to add
code/procedures that iterate through the list of selected items and process
each one. This is considerably more work that simply selecting a single
item and processing that selection.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top