>I changed a form around. I added a second grid to the form. Each grid references one to many transactions per account number of the parent table. I am creating the relations through the data envrionment. When I run the code it limits them down to the account number on the parent table and displays only them, everything works perfect, when I run the same code compiled as an .exe, it shows everything in the table (no limit) and doesn't even come close to finding the right account number. How do I fix something that works? Why does this work fine interactively but not in the exe?

If you select Tools->options, and hold down the shift key while you clock OK, almost all SET commands will be echoed to the command windows. This makes it very easy to create a snippet to recreate the environment from your IDE.

In VFP9 the SET commands will be echoed to the Debug Output window.