1 Reply Latest reply on Jan 30, 2013 2:20 PM by philmodjunk

    How many tables, relate to what table  HELP



      How many tables, relate to what table  HELP


           Im a volunteer for nonprofit organization and I asked if i could work on creating a centralize database, this agency has for offices through out california.

           Although I was not sure what I was getting into, Now i know the basics of databases and of FM

           #1 : Must

           This NPO offers varius services to the community and they want to keep track of every particpant( demographics) that visits the officee for any type of help, as well as the workshops they participate in. 

           #2: ideally i would like to create a database that will make things easier for them.. so i want to design something like...

           Now after some research I have found that most NPO have 3 types of costumers ( participants, donors, and volunteers) all of which are equally important.  of course keeping all tables of the participants will need to stay but how to incorporate the other two ( volunteers and donors into one database). Would be goos idea or no? Overall how many table do i need and how do i relate them to each other, which to which. I gave this to much thought and I think am going over my head

        • 1. Re: How many tables, relate to what table  HELP

               You need one table, for all participants, donors and volunteers. a field in this table can identify which is which and you will need to consider the fact that one individual may be a member of more than one of these categories. How you implement that depends on the needs of the rest of your database. A check box field with a check box for each category is one option. Another option is to use a related table where you add one related record for each category to which that "customer"  belongs.