I have a requirement as follows.
A new table has been created which has got a field with 20character length. The field can take any value but the first 4 characters can follow only15 allowed lists. For example there will be as many transactions with ABCD********* value in this field where * can represent any character. But I want to control the value of a condition type based on teh first four characters of this field.
Ex : If ABCD, i want to maintain a condition record of 100 Dollars, if ZYCD then 200 Dollars and so on.
Is it possible to add only the first four characters as a field in my condition table.
Another case :
I have a field which is a check box. So it can have a value of X or empty. Now I want to use this field in teh condition table and want to maintain some value for the empty field. Is this possible.
Thanks in Advance for the help.