@AF Clarification Needed...

[Kenneth Brody]

On 10/5/2011 12:07 AM, Stanley - stanlyn-com wrote:
> OK Ken, how do I calculate the field number that needs updated based on what
> @af is and use it to update that field.

Well, unless there is a compelling reason not to, why don't you rename the 
fields go they all belong to the same group?  (ie, "A1" for quantity, "A2" 
for item number, "A3" for cost, and so on.)  This will eliminate the problem 
of trying to reference fields in different groups.

> I did see in some routines that was working that an array was created on the
> contiguous groups, however that will not work when they are not contiguous.

Alias the array to the group itself:

     dim ItemNum(5):I2

[...]
> Is there a better way of doing this?

The "correct" way is to put fields that are related into the same letter group.

[...]

-- 
Kenneth Brody