family :id :last_name :address :etc...
children :id :family_id :last_name :first_name :age :etc.... Then to find all children, query the children table with a certain family_id. On 4/23/06, Richard Dillman <[EMAIL PROTECTED]> wrote: > > 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:238500 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
