>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, the settings work the same but you may not have them set to the same values. Also, EXACT and NEAR are scoped to the data session so they may change from settings in a Main program.

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

Oh - I didn't understand the part about two grids for two child tables.

> This code works perfect when I run it by running my main program, but the exe acts different.

Would you be willing to send the project to me so I can see what you see? Send only a few rows of data.