You will need two databases: tabTools intTools_PK Counter/long strName Character/String indexed unique ....
tabRelatedTools intTool_FK Long Foriegn key into tabTools intRelatedTool_FK Long Foriegn key into tabTools Create Maintenance screen/form that lets your update tabTools Create Relation Screen/form that for any 1 tool, lets you select multiple related tools. Depending on the number of tools, this could also be a multi-select list in your maintenance window/screen/form. For example: Form 1 - Select Tool to maintain or Add Tool Form 2 - Enter/Update Tool Attribute and select from list of other tools those that are related. Hope this helps, Andy -----Original Message----- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, November 11, 2002 11:07 AM To: CF-Talk Subject: Generating 'What's Related' 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