AnsweredAssumed Answered

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

Question asked by dansan500 on Sep 9, 2014
Latest reply on Sep 9, 2014 by raybaudi

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?

Outcomes