How to setup a Multi-Select list box

[Dorna Tucker]

I'm fairly new to Access, I need to setup a mult-select list box (or whatever
box that would best meet my need). I have a table that list User Name,
Address, Date of Employment, Termination Date, etc. I need to add the
following:
Dept. worked: (if a user worked in multiple dept, I need to select the
various dept)
HR
Marketing
Accounting
Office Services

 

[Duane Hookom]

You need a junction table that stores the EmployeeID (or primary key from
employee table) and the Department. If Joe had worked in HR and Accounting,
he would have two records in this table:

Joe HR
Joe Accounting

If you really want to store complex data in a single field, you will need to
wait for the next version of Access.