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

Hi Kevin,

I assume your parent table works correctly in that you can locate the correct account number. If you can't then do as Sergey suggested and look at your settings. Specifically, I'd look at SET EXACT, and SET NEAR (and also SET ANSI although you haven't mention SQL statements).

However, since you say that the whole child (I assume) table seems to be showing instead of only rows that are child to the selected row in the parent then I'm wondering if somehow your relations aren't working. Can you determine if the relations are set properly when the form opens? Are you sure nothing changes the relation? Do you have the correct tables selected? Is the child grid refreshing itself properly (or at all) when you move through the parent grid?