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
