filter too long

rixrix

Hello.
Can anyone help me with this?

I have textbox used for input of filter string.
This textbox has TableRelation set to another table.

I am able (using lookup table) to input string for example: "P010556|P050665|P448799|P878787" etc
When I move to another control , textbox is validated with no problem.
Then I pass the filter string to other functions ....

Problem is when I return into the text field and want to add some filter value.
I add next "|" character and when I click arrow to "lookup" , system throes error: Value in filter is too long for type Code20 ...

I would understand if it happens when one of filter values would be greater then 20 chars, but when using "|", I though I can have string as long as textbox is defined.

Can i correct it somehow?

Thank you

kine

You are in situation that whole text is handled as one value, not a filter. You will need to modify the OnLookup on the field, you cannot use the standard functionality if you are entering filter and not one value.