mid statement

[Fairlight]

On Thu, Nov 17, 2005 at 07:55:05PM -0800, Jeff Harrison, the prominent pundit,
witicized:
> I don't think you can use a lookup field as the first
> argument of a mid statement.  I would guess that that
> is what is happening here.  Move the field into a
> dummy field and do the mid on the dummy, then
> re-assign the dummy back to the lookup field.
> 
> I have seen people use both parentheses and/or
> brackets for lookup fields.  They are aparently
> interchangeable.

Okay, scratch that theory.

Next attempt to do it gracefully:  What happens if you lay an array over
the top of the lookup and -then- use the array rather than the lookup?
This gets you around being unable to use variable subscripts on lookups, so
maybe it gets you around any MID limitations as well?  

mark->
-- 
There is no "I" in TEAM.
This would be the primary reason I've chosen not to join one.