>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.