Page 1 of 1

field with several values

Posted: Thu May 08, 2003 5:10 am
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

Posted: Thu May 08, 2003 6:31 am
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.