Contacts Database - Multiple Values for specific field

[nilsdejongh]

I'm looking to create a contacts database - however, I want add a new field called "skills". Within "Skills" I want to add multiple skills per contact and want to be able to search the database for contacts with X skill.



In sum, I'm looking to add multiple values within a field and be able to search for one of those values throughout the database.

Thanks in Advance

[ranman256]

instead of a field, create a new table. A sub table to Contacts that joins on the ContactID
Now you can add infinite skills per person AND search it if needed.

Create a master/child form to enter these. (use the form wizard)

[orange]

Google database design Normalization.

I have given 1 link/site that should get you started.