I'm attempting to do a translate and was wondering if anyone might have a suggestion.
Attribute (or Field) 1 of File1 is a multi-valued foreign key to the Primary Key in File2. File2 contains a Date in Attribute 12. I want the latest date in Attribute 12 of File2 of all the values of Attribute 1 in File1. This is pulling 1 record from Attribute 1 of File1. How can I display the Date (Attribute 12 of File2)? LIST FILE1 1 EVAL "@RECORD<1,DCOUNT(TRANS(FILE2,@RECORD<1>,'12','X'),@VM)>" Jim Volkman http://www.linkedin.com/in/jamesvolkman _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
