Struggling with the design of this beast...

[DanniB23]

Im trying to design a mailing list for new and existing customers, to be used
by 3 different companies.

Each company has its own newsletter to send to one or more customers at each
address, and i need to keep a record of who sends what to who, and when they
sent it.

Each of the 3 companies need to share these customer contacts to cross sell
from their own newsletters.

Ideally( and i know its not gonna be easy) i would love to send these
newsletters by email.

Im really struggling with what i put in each table.. and how i link these
tables together, regarding contact details, dates sent, names, addresses,
fone numbers etc.

If anyone could offer any suggestions.. i would be soooo grateful!!

 

[Anand.V.V.N]

HI Danni,

I hope this helps you

What you can do is have a table that would maintain the details of custmer
detail's as in have a unique customerid for every customer, and other
personal details in a table, personal details woudl include Name, Address
(home/work), phone, mobile,email and any other details you might want. For
the custoemr ID do not use autonumber, use intereger and generate it by
adding 1 to the number or recordds peresent in the table. The next table
would be company details, i.e company ID, letter and address, phone etc. THe
company Id should also not be auto number, next the new letter. The next
table would store new letter details, news letter id, description title,
date, I am not sure what other details for the news letter are, any have a
table called dispatched or something which would have a unique id for the
evey dispatch, again not autonumber, date,customer id, news letter id,company
id. Using a query you can retrive data any time. Nnow about the realitaion
dispatch table would have link to compay, news letter id,company id.

Hope this was not too confusing and hope it helped you

Anand

 

[DanniB23]

Thanks for the advice, can i just confirm it with you, u might have just
saved my job..

1 table for Customer details(name address phone number etc)

1 table for company sending the newsletter (Address etc)

1 table For Newsletters ( spring newsletter description, date, )

1 table for Dispatched (which newsletter sent, to who etc)

Can you explain how i link these all together.. im new to access and not
sure about the relationship thingies!!

 

[Anand.V.V.N]

Hi Danni,

1 table for the customer details name,address,email, phone etc.

1 Table for the company details name,address,email,web-site,phone etc

1 table would have the Newletter details (spring newsletter description,
date, etc.)

1 table for the dispatch detail to whom it was sent, date, by which company
etc.
In this table have customer id, company id,newsleter id so that you store
only the id i.e and not the customer name,company name or newlatter name etc.

All these tables need to have a primary key i.e. a unique key that you can
use and link.

In the customer details table have the customer id as unique key, in the
company details table have company id as the unique key, in the newletter
table have newletterid as the unique key, the dipatch table whoes have a
dispatch id as unique key.

Now to relate these tables.
I gues syou know, but any way the relationships can be found in the Tools
Relationship I think I am not sure though

The dispatch details whould have a relations, the customer table and
dispatch details would be linked by customer id, dispatch table and company
table would be linked with company id, the dispatch table, the disatch table
and hte news letter would be linked by newletter id. the relation can set by
darg and drop. When you open the realtions screen, you have a tabbed dialog
that allows you to add table, add all the tables, you can drag adn drop the
fields of the tables onto the field of the other tabels to set the
relationships. You'll have some referential integrity, cascade update, and
cascade delete I have not used it.

An yway I'll post a link from where you can get a screen shot on creating
relations, I feel that might help you.

Hope this helped you

Anand

 

[Anand.V.V.N]

Hi Danni,

http://www.bcschools.net/staff/AccessHelp.htm

Check this link, this shows how to set the relations.


Is the front end is designed using Visual Basic?

Need any thing else let me know.

Hope you find this link useful.

Anand