Importing record/appending value to value list

[Willy Koch]

Hello,

This one is a bit tricky:

I have a database with people where the email is the primary key. These people can have one or more values from a value list. The value list are different check box categories that the person belongs to, like what type of movie they prefer: Action, Comedy, Cartoon etc.

Is there a script or function that will check for duplicates on import and retain the existing values, and just append the new category? Or in other words:

[email protected] already exists in the database and he likes "Drama" and "Detective movies"

In an external text file, with several people, there's also an entry for

[email protected] "Romantic comedy"

When this duplicate record is found, I'd like the import process to append "Romantic Comedy" to Jack's record, so it reads:

[email protected] "Detective movies", "Drama", "Romantic comedy"

It's given that I've created the new value list entry before importing.

Thanks for any pointers.

Regards,

Willy T. Koch

Norway

[comment]

It would probably be easier to keep two tables: one for people, and one for their preferred genres - with a separate record for each person/genre match.