field with several values

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
micknic
Forum Commoner
Posts: 37
Joined: Thu Feb 27, 2003 1:27 pm
Location: belgium

field with several values

Post by micknic »

Hi,

I'm doing a database in access. I would llike to know if it's possible for a field to have more than one value.

Let me give you more details.
I have a table employee which contains names, numjob, salary,..
I have an other table job which contains numjob, entrydate, iniitialsalary, history.

I would like the field history contins all the job the employee made.
Is it possible???
:D :D :D :D :D :D
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Sure it's possible. Use some seperator (e.g. ";") between the values so that it reads:

job1;job2;job3;job4...

When you read it, explode(";",...). and you got a neat little array of jobs.
Post Reply