File operations will always start from the current directory, ie where the engine is running from. This means that if you on desktop do an io.open("foo", "r") call the system will try to open a file named foo, located in the same folder as the engine.
If you want to do more with folders and folder hierarchies then look into the Lua File System extension in our Asset Portal.