Ok Database Gurus out there. I have a parent / child navigation table. To signify a parent I want the parentID field to be the value of the primary key and if it is a child then parentID would have the value of its parent.
Doing it manually is easy. Is it possible to set the default value of the parentID field to be the primary key of the row? My goal is that if reactor does not enter a value for that field it would default to the pkey value. I am using SQL Server 2000. Thanks for the help, Josh ------------------------------------------------ Joshua Scott Resonant Media Technologies, LLC. http://www.resonantmedia.com | http://blog.resonantmedia.com "It is impossible to get out of a problem by using the same type of thinking that it took to get into the problem." -- Albert Einstein -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
