>Hi,
>
>I am creating my first application in VFP 3.0 and all is going well, except:
>
>I created a report in the report designer containing fields from a parent and a child table. When I first enter VFP and preview the report, it works. However, after opening tables or trying to access the report through a form, I get the following error: CANNOT ACCESS CHARACTERS BEYOND STRING. Is this a memory porblem or something? Does it have to do with the parent-child relationship? Any ideas would be greatly appreciated.
>
>My goal is to have the user input a couple of fields, then have the form select the records that match the criteria, and send only those records to the report to print. Will the report be able to match up the records from the parent and child tables?
>
>Thanks again,
>Eric

Eric,

Check if you have any string manipulation statements like SUBSTR() around. VFP gives this error message when you are trying to access more characters from a string than there are.

You are best off running a SQL query to match your records between parent and child tables, and presenting the result set to the report. You will find things easier to manage.

Sanjay