Unique Purchase Order number list RRS feed

  • Question

  • I have a list called UniquePoNumber. It has 2 fields LastNumber and NextNumber. I would like to assign the calculated column value NextNumber to the form.

    How can I do that?

    MOSS 2007 WSS3.0

    Thursday, February 17, 2011 4:13 PM


  • Hi, you would add that list as a secondary data connection to your form.  Then in Tools > Form Options > Open & Save > Rules > add a rule with a condition of "if UniquePoNumber is blank", the rule would be set a field's value, select UniquePoNumber as the field to set, then in the value click fx.  Then click add function and choose max().  Inside max() click insert a field > choose your secondary data connection to the list with the next number, and select nextnumber.  The function should look like:  max(NextNumber)
    • Marked as answer by Emir Liu Friday, February 25, 2011 2:41 AM
    Thursday, February 17, 2011 4:39 PM