I bit the bullet and created an "Organizations" table. The data normalization process actually led to about eight new tables plus links to a set of "People" related tables. So "Contact" data is presently stored in about sixteen tables, including tables for user-defined attributes.
I also wrote a multi-tab application for maintaining organization/contact data:
http://www.radile.com/rdweb/temp/org100.html
Shows Nathan M. Andelin, a contact at Relational Data Corporation, for example.
It's a little ironic that I've been building package software for years, hoping that people will license it. Now I see myself on the other side of the table, needing a package myself, but wanting to build it myself, as opposed to licensing from a vendor. The shoe is on the other foot.
A number of packages provide a field for indicating an organization's Web site. But I wanted a way to bookmark an unlimited number of URLs for any given organization. So I added a table for organization Web Sites. That's just one example.
I have specific ideas for about eight more new tables. Better get started.
Nathan.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
