Multi Value List

[Dscalf1]

Hey Everyone,



I think I have a pretty simple problem but just cant figure it out.

I have a table name "Action Items" and in that table I have a column named "Assigned To". Assigned to is a multivalue list because sometimes an action item is assigned to more than one person.

I have a form that I want people to fill out to add an action item. In the form Im trying to add the assigned to column where they can select more than one value. However when you try and use the form it doesnt come up as a multivalue list. Just a regular one. Any ideas.

When I try to Add existing fiields it wont let me add just the assigned to its making me add the field assignedTo.Value. Not sure where to go from here..

[orange]

Most people will tell you to avoid multivalued fields.

I recommend you consider a 3 table approach

ActionItem--->ActionItemAssignedTo<-----Person


tblActionItem

ActionItemID
ActionItemName
ActionItemDesc

tblPerson
PersonID
PersonFirstName
PersonLastName


tblActionItemAssignedTo

ActionItemAssigedID
ActionItemID
PersonID




This is a normalized structure that allows mutltiple people to be Assigned to a task
and allows multiple Tasks to be assigned to a person

Good luck

[Bulzie]

As Orange said might be better to multiple tables. But for multivalue fields, you have to go into the table, select that field, look at the bottom for the Lookup tab and for DisplayControl, change it to Combo or List box depending on what you are using, make sure the row source and other values are correct, then down further change Allow Multiple values to Yes. It will save values separated by comma so is a pain to extract sometimes. Also cannot use SQL, must be Access tables.