Hi Ellen,

If I understand your question properly I think this might help.

In the BeforeOpenTables Event of the DE you can put in some code like this.
Providing you are utilizing two database containers.

IF glDeveloper

lcPath = FULLPATH('') + "data\dev.dbc"
THISFORMSET.SETALL("DATABASE",lcPath,"CURSOR")

ELSE

lcPath = FULLPATH('') + "data\live.dbc"
THISFORMSET.SETALL("DATABASE",lcPath,"CURSOR")

ENDIF

Using this method I have been able to add all the tables I want to the DE visually providing both .DBC's have the same table and view names.


>How do I force it to use relative paths? Or can I only do it programatically >and not if I add the tables visually?