In a message dated 8/18/00 8:26:02 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
<< Here is what it looks like:
[ FacilitiesData Table] [FacilitiesParkData Table]
[ParkData Table]
FacilitiesID ------------------ FacilitiesID
Name, etc.
Facilities
ParkID -------------------------------
ParkID
With this relationship does anyone know how to use Cold Fusion to be able to
associate many facilities with a particular park. I am having a hard time
associating all the facilities a particular Park has to offer. >>
It's not a CF question, it's a data modeling question. It would appear that
your many to many relationship is contained or should be contained within the
FacilitiesParkData Table. This table should have two fields ... one for
primary key of FacilitiesData Table and the second for the primary key of
the ParkData Table. So the center table would have an entry for each park a
particular facility belonged to. something like:
[FacilitiesParkData]
Facility_id1 ParkA
Facility_id1 ParkC
Facility_id1 ParkE
Facility_id2 ParkA
Facility_id2 ParkB
Note that this relationship works both ways. That is you can easily get all
facilities located in a given park or all parks that a facility belong to.
Hope this helps.
Bill
Willow Gold
http://www.willowgold.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
