Steve,
Not sure what you are asking, but I would set up the tables thus:
tbl_Schools
school_id ( primary key)
school_name
school_typeID
tbl_SchoolTypes
school_typeID (primary key)
school_type
then you join the tables using the school_typeID field....this structure
will allow you to modify the labels (field: school_type) you use within
tbl_SchoolTypes without have to change the values of school_typeID within
tbl_Schools.
Charles Hanlon
Senior Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
----- Original Message -----
From: "Steven Sprouse" <[EMAIL PROTECTED]>
To: "CF-Talk" <cf-talk@houseoffusion.com>
Sent: Wednesday, July 19, 2006 11:21 AM
Subject: Re: Need help building pages with multiple queries and tables
> So, if my table with SchoolType just has a field with SchoolType and 4
> records of Elementary, Middle, High, and Center/Program...that works?
> Because in my Schools table I have a field called SchoolType, so those two
> tables should link up correct?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247059
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
