I'm sorry Craig, but you are just giving me just enough information to make me want more.

I have my lookup table which contains a memo field with the values. Somewhere in this I use ICASE to handle multiple values and conditions?

I have another memo field which will actually execute the code to do depending on the results of the conditioon in the other memo field?

My goal is to use the packet table to find the correct record in the lookup table, then extract information from both and execute any element-specific code (update what field in what table, etc.) stored in (yet another) memo field in the lookup table.

There is obviously a program that surrounds all of this, but I'm trying to handle the data elements all within the interaction between the packet table and the lookup table.

Could you give me any more detailed information on how to do this? Not looking for the keys to the company code, just a bit more so I don't go down the wrong path and end up having to rewrite this. There are currently 1,800 records in my lookup table and of those probably 75 or so are conditional qualifiers that I will have to handle this for.


>You could do it in one memo using ICASE(), then macro expand the memo.
>
>>Ok, but if there are more than one possible condition, then I would have to have the same number of memo fields to handle the different possible values, right? For example, if there could be 3 possible conditions, then I would need three memo fields, one for each condition.