>Matthew, Use a macro "Repl &myfield with ...." where myfield is the data in the first table.

Remember this also (from VFP help):

"Whenever possible, use EVALUATE( ) or a name expression to replace macro substitution using &. EVALUATE and name expressions execute faster than macro substitution."

Just my $0.02.