need help...

[debra]

I need some help.

I have been asked to set up a mailing list table.

So far I have a customer table which lists the different mailing lists they
would like to recieve (i.e countries/music/tv) but how do I set up the
mailing list table? I know I need 'date' and 'subject' but I also need to
include a list of customers it was sent to - how? (there is one mailing list
per month)

any help would be great

 

[Tim Ferguson]

I have been asked to set up a mailing list table.

A table is easy...

So far I have a customer table which lists the different mailing lists
they would like to recieve (i.e countries/music/tv) but how do I set
up the mailing list table? I know I need 'date' and 'subject' but I
also need to include a list of customers it was sent to - how? (there
is one mailing list per month)

.... but this sounds like a little more than one table. It seems to me you
have a number of things to model vis:

People // these are the people you send things to

MailingLists // these are the countries, music, tv etc lists. You
// seem to call this "subject" as well, or is that
// something different?

Subscriptions // this stores which people want to receive
// which lists

Mailings // every time a mailing is sent out, need the date sent
// and which MailingList it came from

Mail // this records which Mailing was actually sent to which Person



If you need help with the relationships, please post back; but this seems
from here to be a reasonable starting point.

Best wishes


Tim F