Hi All,
I am trying to add a Field [Previous_Returns] that looks up the value of Field [Serial_Number] to see if it has been entered before.
If it has been entered before then [Previous_Returns] should equal [RER_Number] of the previous entry/entries of [Serial_Number].
If it has not been entered before then [Previous_Returns] should read "None".
Also if the lookup finds multiple entries is there a way to easily and clearly display these?
If this made no sense I apologise I always find it hard to type what I mean!
Thanks in advance!
I am trying to add a Field [Previous_Returns] that looks up the value of Field [Serial_Number] to see if it has been entered before.
If it has been entered before then [Previous_Returns] should equal [RER_Number] of the previous entry/entries of [Serial_Number].
If it has not been entered before then [Previous_Returns] should read "None".
Also if the lookup finds multiple entries is there a way to easily and clearly display these?
If this made no sense I apologise I always find it hard to type what I mean!
Thanks in advance!