yes, I'll try to explain as best I can.... let's say you have 2 tables....
Table one has 3 fields - key, class, and instructor. key is the primary key,
name is the class name, and instructor is the key value from the instructer
table. When you set the instructer column up as a foreign key, the database
won't let you delete the record from the instructor table if that key value
is being used in the first table. Confused?
adam churvais is on this list and teaches db classess... you might want to
hook up with him.
-george
>From: Paul Ihrig <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Community <[EMAIL PROTECTED]>
>Subject: RE: grrr.. how do i build it better.
>Date: Thu, 17 May 2001 11:11:16 -0400
>
>not sure what a foreign key is.
>that is different from a primary key?
>thanks
>-paul
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
