Richard, It sounds like a nested set model might be useful in this case.
See http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=235427 for more information, or search google for "nested set". If this looks like it will work for you, contact me off-list, and I can give you some example code. -- Mike Wolfe > -----Original Message----- > From: Richard Dillman [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 23, 2006 8:43 PM > To: CF-Talk > Subject: OT: SQL Delema > > heres the deal, I need to build a contact management piece > to add into the > registration app im working on. > > The contacts need to relate to eachother as they are > children. Foster Care > is the underlying theme. > > Im a bit at a loss for a way for multiple children to be related to > eachother. say a family of 8 with each child haveing a > pointer to each of > the other 7. > > I think this would test the limits of my SQL knowledge. > > CF MX7 latest patches/ SQL Server 2000 > > btw thanks Robert for your kind offer last week but I've > found that what > they are asking for is very specialized so ill have to build > everything from > scratch. > > -- > Richard Dillman > [EMAIL PROTECTED] > (317) 916-8341 > > "The most important step is always the first one." > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
