Well, in most cases, isn't `Gender` assigned at INSERT of a PARTY-PERSON entity by an agent that is able to determine gender - remember "Pat" on SNL? If so, then it would be known (unless NULL is allowed f/`Gender') which set of TITLES are valid, because the attribute of `Gender` would be assigned when the record was created. Of course, even if my assumptions are correct here, it probably doesn't help Duey's original problem, as I think he was working the other direction, trying to determine `Gender` by virtue of the value of TITLE/PREFIX (fm essentially a string-list), wherefrom he suggested an "IFIN()" function.
However, I intend to re-visit & study Larry's previous solution description. I think it'll be filed in my "Inbox\RBase\Potentially_Interesting_Or_Useful" folder. Later, Steve in Memphis ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 12:30 PM Subject: Re: IFIN function possibility > > I like your solutions, but what do you do if you > > have both male & female > > Rabbis? > > The problem is, presumabely, not soluble in that > situation. I have an application in which heavy use > is made of the person's gender, and in that case the > clients are required to choose Male or Female. > > I'm not sure what the original poster does when the > gender can't be determined from the Honorific -- > possibly only Mr., Ms., Mrs., and Miss are allowed? > -- > Larry > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
