2 Replies Latest reply on Jan 1, 2012 12:26 PM by LaRetta_1

    GetNextSerialNumber

    dzittin

      Title

      GetNextSerialNumber

      Post

      Inside a debugging custom dialog, I have:

      Get(FileName) & "    " &
      GetNextSerialValue ( Get(FileName) ; MyTable::MyID)

      The get(FileName) is there for histeric reasons. The get filename works fine. The getnextserial value returns nothing. What am I doing wrong? I looked at the table options for MyTable::MyID via the manage database panel and it is an Auto-Enter value, serial number is checked, next value is currently 1141 and increment is by one. When I create a new record, the serial # is incremented correctly. Everything works except the getnextserialvalue. The field is not hidden when I view the table.

      Ideas?