I use the following procedure to navigate from one database to another in PanX (this worked until recently - just got back from my Hawaii vacation):
local lvfolder lvfolder=folderpath(dbinfo("Folder","")) save closefile if info(“files”)="Departments" opensecret lvfolder+"Departments" window "Departments:Secret" opensheet OpenForm "D Data Entry" selectall else OpenFile lvfolder+"Departments" Endif
When I run this procedure, it will close the open database (Retention Schedule) and Open the “Departments”. But while in “Departments” I click the procedure to open the “Retention Schedule” – and it doesn’t open. Quitting Pan and clicking either database from the desktop – neither will open. I have to open another database and use the “View Organizer” to reopen both.
I also used my original Pan6 procedure just to double check:
local lvfolder lvfolder=folderpath(dbinfo("Folder","")) OpenForm "Data Entry" NoWindowSave Save CloseFile OpenFile lvfolder+"Departments"
It closes the active database and opens the one I want, but the database I closed will no longer open - unless I use the view organizer.