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

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