To summarize, your problem is with a relation established in the DE of a report. All runs OK from the debugger or interactively but not from an APP or EXE you have built.
If so, I would think you have a rogue copy of the report that is included in your project. Modify the project and click on that item in the report list. Look at the description and path in the bottom box of the PM. If you do not have this activated, right click on the PM titlebar and click the
Display Description/Path option. You may need to remove that report from the project and add back the correct version of that report.
In general, I always exclude reports and provide them in their own subdirectory. That way, when the users inevitably want a change in a report, I provide a new copy instead of a new compiled app.
Mark McCasland
Midlothian, TX USA