Try: TRANS(FILE2, FILE1.FIELD1, "FILE2.FIELD12", "X"); MAXIMUM(@)
David A. Green (480) 813-1725 DAG Consulting -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of James Patrick Volkman Sent: Friday, May 21, 2010 9:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] TRANSLATING LAST VALUE FROM A SINGLE VALUE 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users