1 Reply Latest reply on Sep 9, 2014 11:42 PM by raybaudi

    Select from Field, if empty, select from another field, if empty, select from a third field

    dansan500

      Title

      Select from Field, if empty, select from another field, if empty, select from a third field

      Post

      I have a field called - Item

      I want to auto enter to the Item field using one of these:

      OEM Part

      MFG Part

      Comp Part

      If OEM Part is empty then load from MFG Part, and if that is empty, load from Comp Part.

      I tried the Case command but it didn't work for me.

      Can you Help?