Select one or more values from a list

[Kenoli]

This is what I want to do:

Associate a record in a person table with one or more skills listed as records (each record has a single field with a skill name in it) in a skills table. Let the person enterring data select a skill and have it associated with the record in the person table record or add a skill if what they want is not there. Let subsequent users see the list of all skills including the added ones and do the same themselves. I would like a person record to be able to be associated with more than one skill.

I am trying to do this using a value list associated with records in a related "skills" table. I've also tried doing this using a portal.

I can't get anything to work.

Please help!

[Kenoli]

I figured out how to do this, using a value list linked via a linking table to a table with the values I want enterred as records.

I am interested in an additional refinedment. When a user chooses "other," they are allowed to add a new record (thus a new skill), but they are also able to delete existing records. I can see that this would turn into a mess. Can I constrain this so a user can only add a record. In the relationship link, I have the box checked for adding a record and the box for deleting one unchecked.

Looking forward to somones insight.

Thanks,

--Kenoli