Hi all i would like advice as how to plan better for this db and what info should be on different tables etc... if anyone could do this for small money pm me please Database for non profit org. that includes 3000 names, addresses, notes regarding family, tracking and input information regarding most recent visit. Database requirements: * The db needs to be able to be sorted into small groups, which represent a small area of the city, yet stay within the main database. * Afterwards, each group needs to be routed individually and printed, in a small format including only selected columns. (ie: not entire history, just 2 most recent visits and donations) * Once the custom group is ready for routing, it should still be connected to the main database – so that any editing of address or custom group number, will automatically update the main db. * Next to every family name, besides its contact information, address, telephone etc., we need to record whether we attempted to visit them this holiday and what occurred. Ie: “holiday1-2009†“holiday2-2009†“holiday3-2009†and so on for every year. * Need to be able to make totals per year Ie: holiday2-2009 – how many packages were sent and donations received. * Need to be able to make mailings, based on names in db. * Need to work with main db at decent speed (needs to be meant to work with many names, not crash very often). General setup: * group number * address * last name, name * notes regarding location (apartment number, staircase, floor, phone,cell, email etc.) * spouse name * history (of previous visits) * donation history (1. family donation history 2. donations this holiday 3. donations this year) After each holiday, the visits need to be recorded and main database needs to be edited with the following information: * address correct (moved, died, not found, not home) * person (met or not home) * reaction (happy, upset) * what occurred (gave them holiday package, brochure, nothing etc.) * donation (no, yes, by mail / at home, how much) * follow- up (something to be taken care of now) * new contact information to be inserted (ie: birthday, children, point of interest) log of changed info necessary, who changed? what changed? when changed? preferably done using open source