List ofGroups

[Stevenson Hickey]

Hi!
I am trying to figure out how to build a database of a
list of groups so that I can record contact info with the
groups and keep track of emails received and sent and of
some other data which is time dependent. The regular
Access Contacts database is absolutely wrong as it is
focused on individuals.

I am more an Access user now (although I used to program
it long ago), so I am drawing a blank on this.

Any help will be greatly apprciated!

Stevenson Hickey
PS please respnd also to my email address above.

 

[Gina]

The best database design starts with a pencil (with good
eraser) and paper. You need to first write down WHAT you
want to store... Then break that into tables being
careful not store redundent information.. All the time
thinking what am I going to want reporting on that way you
don't store lets say, last name and first name in the same
table only to find out you want a report on only the
Jones'.

Example:
Table1
GroupdID
GroupName
GroupAddress
GroupeMail

Table2
GroupID
eMailRecieved (Do you want to store eMail note or just
date and time)
FollowUpRequired
DateFollowUp

Hope that helps...