Jillian, It depends on how the data is tructured in the database, i.e. how do you identify whether or not a tool is used in the removal of an alternator in a 1997 Ford Taurus. This is what relational databases were designed for. But the table structure needs to be set up, or normalized, for relational operations.
Select queries using JOINs and subqueries are the typical mechanism for incorporating data from multiple tables or multiple instances of the same table into one result set. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ---------- Original Message ---------------------------------- From: "Jillian Carroll" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 11 Nov 2002 11:06:31 -0600 >I'm having a hard time visualizing what I need to do to make this an elegant >solution... so I'm hoping somebody out there has done this and can give me >some insight. > >What I want to do is this: > >I have a database of tools, and any 1 tool may be associated with a group of >tools (also in the database) that are related. > >For instance: > >As a technician, you pull up the wrench used for removing alternators from a >1997 Ford Taurus. When you pull up this wrench, you also see a list of >'related tools' that are also used/required for removing alternators from a >1997 Ford Taurus. > >My problem is that there are thousands of tools in the database and there >could be any number of 'what's related' tools for a single tool. > >How can I create a dialogue for easily adding 'what's related' tools? > >Any help would be greatly appreciated. > >THANKS! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com