On Wed, Sep 1, 2010 at 6:41 PM, Dan Covill <[email protected]> wrote: > On 9/1/2010 11:28 AM, MB Software Solutions, LLC wrote: >> How do you handle the scenario where it's multiple spouses (ex-wife #1, >> ex-wife #2, current wife)? >> > > SpouseKey2 and SpouseKey3! <g> I have very few of these, fortunately > (one is my brother!). I haven't worked out how to pick which wife when > adding a child. ----------------------
You have to normalize this. RowID, personID, RelationshipTypeID, RelatedPersonID How else can you handle Polygamists in TX or UT ??? This is the perfect fit for the recursion we spoke about earlier this week and why you NEED to have it and use it. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
