3 Replies Latest reply on Jul 9, 2010 10:15 AM by philmodjunk

    count records and automatic entries

    AlexdeMarco

      Title

      count records and automatic entries

      Post

      Hi all,

      I'm new to Filemaker, I have a problem in setting a simple script. What should be done by the script is:

      I have a table with 2 fields ID and NUMBER

      - read the content of the field ID and assign it to a variable A

      - count the number of records in the Table that have the value A in the field ID and assign it to a variable COUNTS

      - create a new record

      - set the value of the field NUMBER as COUNTS + 1

      thanks

      alex