Select from Field, if empty, select from another field, if empty, select from a third field
I have a field called - Item
I want to auto enter to the Item field using one of these:
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?