>>I am setting up a table where one of the fields in the table actually desribes the name of the field that I must use in a seperate table. The problem is that VFP will not allow me to do with because it thinks that I am referencing a string rather than a field name. Is there a way around this.
>>
>>thanking you in advance
>Matthew,
>
>Macro expansion, if that is what you are using, only works for character memory variables. It does not work on fields. Therefor you need to;
>
> lcMyFieldName = TableAlias.FieldName
> REPLACE &lcMyFieldName WITH "Whatever"

Faster:

REPLACE (TableAlias.FieldName) with "Whatever"

Vlad