Hi Henry ----

Try this: Get rid of the table name part of cRecord_field_name by storing it as a separate value, ie, cSource_table, and only storing the field name in cRecord_field_name. Then try this:

SELECT (cSource_table)
SCATTER FIELDS (cRecord_field_name), etc etc....

Failing this, try SCATTER &cRecord_field_name.

I still think that the "." is causing problems.


>
>Thanks for your reply to my question. Unfortunately, when I called SCATTER in the following way:
>
>SCATTER FIELDS (cRecord_field_name), (cFirstname_field_name), ... TO laFieldInfo
>
>where '...' represents the rest of the field names. I got a general syntax error. I set up the values of THIS.record_field_name, THIS.firstname_field_name, etc. by calling the function in my original message. I then declared some LOCAL variables (i.e. cRecord_Field_Name, etc.) and assigned them the values of THIS.record_field_name, etc.
>
>Have I done something else wrong?
>
>Thanks again,
>
>Henry