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


Yes my parent works fine on both. Wouldn't commands like set exact and such work the same way running the code as it would running an exe made from it?

Yes, no SQL, no database, simple form with relations, I didn't even code the set relation, I dragged and dropped in the data environment. Yes the relation works perfectly fine on both tables and grids when run, but does not work on either through the exe (it shows the whole table and pointer at wrong place and usually not even eof). The parent does not have a grid. An inputbox is used to enter the account. The account info is displayed and linked (relation) to 2 grids to search the account number in both. Then a button to switch between visibility of them. This code works perfect when I run it by running my main program, but the exe acts different. That is why I am having such a problem with this because it implies the code is correct or it would not work properly when run from within the code.