Uri10

They are all existing file maker databases and they were created before I began working for the organization. I assume they were created seperately because someone lacked the forethought to realize they might contain related information. Personally I think they should be consolidated but I still have to sell that idea.

I know I'm probably asking the same questions as everybody else but whatever... here it goes I'm another confused newbie that needs to be bailed out. I work for a non-profit environmental organization that has three databases of information. Each database contains specific information about the work that the people listed on the contact section of the database have done. What I would like to do is create a fourth master list of contact information that contains all the contact information of the people in the databases. Also I would like to create a radio button that states whether or not the specific contact would like to recieve an e-newsletter. What I was hoping to do is import the data from the similiarly defined fields ie names, email, address in the three databases automatically so that if the contact information is altered in the indiviual databases it will be reflected on the master contact list. Also if it is possible (this sounds more webpage than FMP but maybe it can work) I would like to make a button that launches all the detailed project information contained in the other databases that relates to the contact name or organization found in the master list. Oh and that may be contained in several sub-pages rather than in one place. I know nobody has any incentive to respond to this but any help from an experienced person would be GREATLY appreciated by me (a poor college student) and the environment which definately needs more help than I do.