Relating one email to a list of many...

[MartinX]

I got a database with clients, and it contains a text-field for email adresses. Some entries in the database has several email adresses entered in this field, seperated with a newline.

Now, I got another database with orders. This database also has a textfield for email adresses, but they always contain just one adress and no more.

Which is the best way to relate these two databases? I am willing to modify the clients database if it isn't too time-consuming (6600 fields...)

[Sequential Logic]

I would add a ClientsEMail table with ID, ClientID, & EMAilAddress

[TerenceM]

If your field of client e-mail addresses is just a return-delimited ValueList, you shouldn't have to change anything. If a field in a relationship contains multiple values, a match is returned if any one of those values matches (that is, the order database doesn't have to list all of a given client's e-mail addresses, just one of them).

-Terence