Hi
Can you tell me i seem to be a bit confused, i am working on a database that has a table with one skill for an individual but i need it to contain more then one skill it also has a table linking to it with the skill id.
Should i create another table or modifiy the one i have.
i was trying to modifiy the skills table but could not get that to work.
I want to run some queries to match individual skills with job skills
cheers

Hi

You should have one table of people and one table of skills belonging to those people. A person is registered only once but they can have many skills.

Have an autonumber in the people table (which is generated when you add a new person) then use the same number to link the skills with the people.

Col
:cool: