Find and

G

gmore

Hello,

I am trying to get a result based on a value in a column. Here's the thing.

I've got 4 columns as follows with data that I have determined in a query:

Part No Status Type Validation
-------- -------- ------- ------------
KSAR0001-SDS Active REB-NEW OK (Find if there is a REB
equivalent)
7000000 Active REB-NEW OK
KSAR0001-RB Active MM Should be REB
7000000-RB Active REB OK
7000001 Active MM Should be REB-NEW
7000001-RB Active MM Should be REB

What I want to get is every Part No validated with the Type set up in the
database and have a message appearing in the column validation. For instance,
to determine if a Part Type should REB-NEW, it has to have its equivalent
with -RB, but to do this, I will have to make a search in the column Part and
find if there is an equivalent Part No ending with -RB and then put a text
message in the column validation if the type is set up correctly or not.

Secondly, as soon as a Part No end up with -RB, it is a REB, so it's not
complicated in this case because I don't have to look for an equivalent...

Do you follow me? Please, let me know if you should need more details.

Thanks for your help,
gmore
 
Top