>I am trying to open a table up a number of times dependant on how many records are in a table named vwmactionnot. The problem is it is not substituting the alias name for lncount. Any ideas waht I am doing wrong?

Accessing different parts of the same alias is just as much work. Even though there are different aliases, I suspect you will have to navigate to different parts per alias. It may even be faster to use only a single alias since there would be neither the code to open the alias nor the code to select a different alias.

>
>

>lncount = 1
>DO WHILE vwmactionnot.actionno = 1
>	USE vwmmembership IN 0 ALIAS &lncount again
>	SELECT lncount
>	SET ORDER TO username
>	BROWSE NOINIT nowait
>	lncount = lncount + 1
>	SKIP
>ENDDO
>