If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Selecting more then one item in a lookup field.
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. |
#2
|
|||
|
|||
Selecting more then one item in a lookup field.
"Sara" wrote in message
... 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. 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 |
#3
|
|||
|
|||
Selecting more then one item in a lookup field.
TblCourse
CourseID CourseName TblPracticeArea PracticeAreaID PracticeArea TblCoursePracticeArea CoursePracticeAreaID CourseID PracticeAreaID First create a form based on TblPracticeArea to enter all practice areas. Then create a form/subform. Base the main form on TblCourse and the subform on TblCoursePracticeArea. Besure the LinkMaster and LinkChild properties are set to CourseID. You will then be able to enter all courses in the main form and for each course you will be abe to enter a list of practice areas the course applies to in the subform. Steve "Sara" wrote in message ... 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. |
#4
|
|||
|
|||
Selecting more then one item in a lookup field.
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 "Sara" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|