5 Replies Latest reply on Oct 26, 2011 2:54 PM by philmodjunk

    How Do I Get Data To Repeat in a Field Until I Decide to Change It?

    jdanniel

      Title

      How Do I Get Data To Repeat in a Field Until I Decide to Change It?

      Post

      Hi everyone.

      I'm using FM 11 Advanced, and am designing a fairly simple flat-file database.  But I'm not sure how to do one thing, so I'm requesting some assistance, please.

      I have a couple of fields that I would like to retain the same data each time I create a new record, until or unless I manually change the data.

      For example, let's say I have a numeric field called Storage Box Number.  I'd like to type the number 1 in it, and I want the number 1 to appear in that field for each new record, until I decide to change it and type in 2 instead.  And then, 2 should keep appearing in that box until I change it to 3…and so on.

      (I hope I explained that clearly.)

      I assume this is possible, but am not sure how to do it.  Would anyone care to tell me the procedure?  Thank you very much!   Jd