>>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?
>
>Compare environment settings (SET) in the development and runtime.


Not sure what you mean there. Wouldn't the settings be the same? I also have other forms that use the same kind of relation types through the data environment on a grid and they work fine. It is just the one on this form giving me trouble and only during runtime (exe).