Yes!
Bill, thanks I didn't know if my little diagram represented what I wanted to
show properly but you said it right. That is what I have done with my table
relationship.
However, I am having a very difficult time with the Cold Fusion side of
things. For example, I am trying to figure out how to make a form that will
allow me to add facilities for a particular park.
I am a newbie so that may sound very elementary. I am trying to make a form
that will allow me to assign many facilities that a particular park has.
So the center table (that creates the many-many relationship) looks like
this:
[FacilitiesParkData Table]
FacilitiesID ParkID
23 14
5 14
6 14
and so on.
What is the best way to do this on the Cold Fusion side of things?
Thanks,
Darren
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 18, 2000 7:13 PM
Subject: Re: Funky Relational Tables
> 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.
>
------------------------------------------------------------------------------
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.
