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

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.