2 Replies Latest reply on Sep 27, 2011 11:59 AM by philmodjunk

    Getting field contents and setting field

    JoelMG

      Title

      Getting field contents and setting field

      Post

      Two beginner's questions, please:

      The scenario:  A script which takes user input and generates new records in one table/layout from a found set of records in another table/layout.

      Specificially:  The script now does a Find, generating a found set in Layout1.  The user is then asked for an ID number.  I want to generate new records in Layout2, placing the ID number in Field1 of all new records, and populating Field2 with contents of a field from Layout1 of the found set.

      The two problems I'm having:

      Question 1: How do I place the ID number in the new records?  It automatically places it in new record 1.  How do I place it in the others?

      Question 2: How do I "get" the contents of a field from Layout1 into Layout2?  I understand Set Field.  But getField in a calculation gets the contents of only the first record.  Can I specify to get field contents from the next record in the set?

      I'd appreciate any advice.  Thanks.

      Joel