I'd have a tag file of product tags each one with a PK. Tag Table: PK_Tag I Tag_Id c(64)
Customer Table: PK_Customer I Customer_Id C(32) Then have a Customer tag table: PK_Tag I PK_Customer I add a record into this customer tag table for each tag you want to add in where the PK_Tag is the tag in the Tag Table and the PK)Customer is the customer PK. In the same way you can relate Tags from the tag table into groups via a Group_Tag table and then the sql select is fairly simple to get all customers who have the relevant tags. Other than that you really need a free text search/indec facility that unfortunately VFP doesn't have. There is one about called PHDbase which works fine but only single user. I spoke the the author some time ago about him releasing the source to open source but after a few discussions he never came back to me. Personally I would migrate the whole lot to M$ SQLExpress and make VFP the client as it has free text indexes built in if the above solution in VFP isn't workable. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Gary Jeurink Sent: 14 August 2013 16:57 To: [email protected] Subject: associations 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/[email protected] ** 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.
