Well.. oneway to do it is to create a new relationship table.. i.e
tblRelatedTrails
> relationID
> trailID
> relatedTrailID
and when doing a select for review you can do a sub select on the
relatedTrails table.. and use IN()
anotherway is to use the geo info of the trails.. and select.. all
reviews falling in a radius.
John Munyan wrote:
> Yes, the crux of the question is how to handle the subset question. In the
> below example a review left for SnowLake would
be availble for the Snowlake Hike only. If I user left a review for Gem
lake, then the review should be available for SnowLake or Gemlake since
you pass by Snow lake on your way to Gem lake. Similiarly, Wright
Mountain, would show reviews left for Wright Mountain, but also for Gem
Lake and Snow lake since you pass by them en route to Wright Mountain.
>
> Thus how do you handle nesting of these elements where one is a subset of
> another...
>
> Thanks,
>
> John
>
--
Umer Farooq
Octadyne Systems
+1 (519) 489-1119 voice
+1 (519) 635-2795 mobile
+1 (530) 326-3586 fax
WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION:
http://www.Non-ProfitSites.biz
WARNING: ------------------------------- The information contained in
this document and attachments is confidential and intended only for the
person(s) named above. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution, or any other
use of the information is strictly prohibited. If you have received
this document by mistake, please notify the sender immediately and
destroy this document and attachments without making any copy of any kind.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193150
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
