Have you tried to get the nextid from the arschema and left pad it with the necessary 0's and the Prefix?
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Shawn Stonequist Sent: Thursday, August 16, 2007 8:30 AM To: [email protected] Subject: Table Field Question - Set Fields based on Column Greetings List! I currently have a table field that, among other things, shows the Entry ID, and various "Target Due" times from data in another Form. Using a COLMIN function, I'm able to set a field with the "Next Due Time" showing the time that the next record is due. However, I'd also like to set the Entry ID of the next record due itself. I'd like to do this from the table, as the source schema is rather large and is polled once already to create the results in the table. Is this possible? Thx! Shawn Stonequist EMNS, Inc. Remedy 6.3 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.11.19/956 - Release Date: 8/16/2007 9:48 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
