Sounds like a Many to Many listing table. VendorID | AssociationID
Association is your "topic" This way you do not move any vendors or lose any notes. On Wed, Aug 14, 2013 at 10:57 AM, Gary Jeurink <[email protected]>wrote: > I have a vendors file that has grown to a fairly large size. I am finding > that I want to connect several vendors together by topic. Yesterday I had > one vendor that sells rubber molds, another whole sells concrete dyes and > they recommend retailer of their products and then I've consulted an art > firm to get recommendations for colors for a garden project of interlocking > pavers. > > > > I have notes in memo fields of each vendor but I want to know what is the > re4commended way to create associated list of companies by topic. In this > case it would be concrete pavers. Keywords would be like concrete, > interlocking pavers, release agents, fiber glass additives, concrete > coloring, sand, gravel, and color blending. > > > > Gary Jeurink > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJGREGr-cFAPsRcw7bcFXh2a=nqzfzubksts5m3byq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
