Thilo, I think this is what I need, but I can't seem to get it to work.
Here's how I have it setup: Active Link 1: Run If: Return on Field "Next Due" Action 1: Set Field "Next Due" with Colmin (Column "Target") Action 2: Call Guide "Next Due IDs" w/ Table Loop Active Link Guide "Next Due IDs" contains Active Link 2 Active Link 2: Run If: Field "Next Due" = Column "Target" Action 1: Set Field "Next Due ID" = Column "ID" Action 2: Exit Guide Most grateful for ALL help!!!! Shawn Stonequist EMNS, Inc. Remedy 6.3 -----Original Message----- From: Thilo Stapff [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 2:31 PM Subject: Re: Table Field Question - Set Fields based on Column You might implement a table loop guide. This guide would contain a single Active Link that does something like the following: Run If: 'Next Due Time' = 'tmp_colmin' Action 1: Set Fields from current screen 'tmp_entry_id' = 'column_entry_id' Action 2: Exit Guide This method might be too slow if the table contains a large number of rows. Regards, Thilo Stapff Shawn Stonequist wrote: > 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 > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
