Reading values from tables

[woodyinoz]

Hi again all!

Once again I have a question!

Basically I want to be able to say that if CSMID1.Value is located anywhere in the CSMID field then CSMID1 will be blue but if not then CSMID1 will be red. These 2 fields are in seperate tables.
I want to be able to search the CSMID field to try and find a match for the selected value in CSMID1.

Any ideas?

 

[woodyinoz]

I've found the answer! For all you intereted the code is as follows:-

method newValue(var eventInfo Event)

if CSMID2.isblank()
then
CSMID1.font.color = Red
else
CSMID1.font.color = Blue
endif

endMethod

You need to attach this to the CSMID1 label.

Thanks anyway!