I have a form that is fed by a certain table. This table connects to
an intermeddiate table and then a look up table. All of this is done
to accomplish a many-to-many relationship. Imagine that the form's
table represents employees in a company and let's assume that an
employee can belong to multiple departments. The lookup table
mentioned above is represents the departments and the intermediate
table represents the many-to-many relationship. I would like to have
an employee input form that contains a drop-down list that allows a
user to select the multiple departments someone can belong to. Please
advise. Thanks in advance