I'd write this as an A-correlative rather and F:
On Mon, Dec 10, 2012 at 12:45 PM, David Grenfell <[email protected]>wrote: > Hi ALL: > > I've gotten a little rusty with the correlative functions and need some > guidance on this one > > I have one attribute for members first name (att 1) and another for spouse > (att 11) > > If the spouse contains anything I want a dummy attribute "bothnames" to > contain first name "and" spouse first name. In other words, "JACK AND MARY" > > Here is the fly in the ointment. The spouse first name might be > "*":spouse ( looks like "*MARY") indicating that he/she is deceased, in > which case it should be treated as none existent also and just return the > first name of record holder. > > Any help always appreciated. > > Dave Grenfell > > > -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > > > > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
