>I want to create as many variables as there are records in the table and assign them a value that is a field in the table. So, I want to end up with something like this:
>

>Cpt1 = "This is one"
>Cpt2 = "This is two"
>

>This is the simple SCAN I want to work it in:

See inside from the top of my head.

local lcVarName 
	ix = 1
	SCAN
		* Make a variable based on m.ix like "Cpt1" then "Cpt2" etc, and assign them a value from the table until the scan is done.
                                         lcVarName = "cpt" + transform(m.ix)
                                          local &lcVarName
                                          store myField to ("m." + lcVarName)
		ix = m.ix + 1

	ENDSCAN