> 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. You can even have all the info that's the same for all children be in the "family" record instead of in each "child" record. Take a look at the business logic, see what grouping is best. Normalizing the data is a good idea, so you may think of something along the lines of: persons: person_id first_name last_name households household_id person_id_hoh (head of household) childs: child_id person_id household_id Or something like that. Zaphod beat me too it, it looks like. :-) It really depends on the business logic tho... it may make more sense to not have "childs" at all, and instead have "household members", with a "type" of household member being "child" or "parent", etc.. Just depends on what you gotta do, the data at hand, ad infinitum. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238501 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
