What's the best way to set this up?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Susanna (anonymous_at_discussions.microsoft.com)
Date: 03/13/04 

Date: Fri, 12 Mar 2004 17:01:08 -0800

Hey there.

I'm an intern at an arts non-profit. I was today given the
task of redoing the entire mailing list and database
system. I'm using 2002 Access, and Microsoft Office
Professional.

Here's the problem. Currently, there are a bunch of
different tables within a single database, one for
artists, one for curators, one for mailing list, etc.

But this means that when a new entry needs to be entered,
it must usually be entered in five different places.

The information is vastly out-of-date to begin with, so I
must find out what is current and such in any case, so it
definitely makes sense to redo the entire thing. (At least
it seems to.)

What I want to know is whether there is some way to set it
up so I can enter the information once into the form, and
then simply say, "put this into the artists table, the
curator table, AND the mailing list table." and it will.

And if there is then presumably some way to edit the
information and find it, so that if a mailing list person
suddenly decides to become a member, I could go and just
find their name in the mailing list, and say "put all this
person's information into the membership table, too."

Another issue is that the computers are all networked, so
one person could have the artists table open, and another
could be doing a mail merge with the mailing list open,
but they couldn't both have the artists open at the same
time.

That means that storing all the information in one table
(which would cumbersomly have to have separate columns to
determine what functions the person had, volunteer, donor,
artist, etc.) is not an option, because everyone in the
office is constantly having to have various tables open,
and needs to be able to access (no pun intended) the
information all at once, or as close as possible to all at
once.

Thanks so much for any help!

Relevant Pages

  • HOW DO i MAKE A LIST FOR SONGS?
    ... I don't have a database application. ... >different artists. ... >identifier to each instance of the song. ... if your search criteria is the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: [PHP] MP3 Ripping
    ... But what if the CD has music from different artists? ... and letting people using a simple interface select some songs. ... A database is there to hold your data, and basically display it in a format ... Just would be nice if there was something in PHP. ...
    (php.general)
  • Re: Problem with mod_rewrite and replacing spaces in URL
    ... artists themselves? ... and the corresponding database lookup. ... I don't understand why the function fails? ... "Britney Spears") only AFTER I transform the database version to the ...
    (comp.lang.php)
  • Re: Whats the best way to set this up?
    ... >different tables within a single database, ... >artists, one for curators, one for mailing list, etc. ... Membership: each record in this table has a PersonID ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Louis Stewart - Vid
    ... I just noticed that he had been elected a member of an Irish body ... small amount of money but it allows artists who would struggle ... years ago and it failed because some people did not consider Jazz to ...
    (rec.music.makers.guitar.jazz)