RE: OT: SQL Delema

2006-04-24 Thread Loathe
- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 1:54 AM To: CF-Talk Subject: Re: OT: SQL Delema Thanks guys, I knew i was going about it the wrong way and chasing my tail. they just sent me a question what if they need to split up families later... adopting 8

Re: OT: SQL Delema

2006-04-24 Thread Denny Valliant
they just sent me a question what if they need to split up families later... adopting 8 children at once is a pretty good trick by itself, so sometimes they send them out in smaller groups. And I actually remember a family of kids that got split up 4 or 5 different ways till they got

OT: SQL Delema

2006-04-23 Thread Richard Dillman
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

Re: OT: SQL Delema

2006-04-23 Thread Zaphod Beeblebrox
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

Re: OT: SQL Delema

2006-04-23 Thread Denny Valliant
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. You hit it on the head with this comment. You need families! Instead of relating each child to each child, relate each child to a family.

Re: OT: SQL Delema

2006-04-23 Thread Richard Dillman
Thanks guys, I knew i was going about it the wrong way and chasing my tail. they just sent me a question what if they need to split up families later... adopting 8 children at once is a pretty good trick by itself, so sometimes they send them out in smaller groups. And I actually remember a