>>Second table needed because if I need to do a select SQL it will be speedier to get the needed informations I have to send to the customer from the first table. Second table would contain references to all the emails that were sent over the years. So each new year I transfer (add) references of what was sent the preceding year.
>>
>
>What kind of volume are you talking about? Unless you're dealing with millions of emails, there's no reason to use two tables. Just make sure you have the right indexes to pull out the data you need to send to your customer.
>
>Tamar
I guess that I should begin with one table and if there's a problem eventually I'll just have to adapt and modify the structures. Thanks for that feedback.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé