Sometimes when I create relationships, whether between tables within a file, or between files, they simply do not work, meaning an attempt to create a portal shows lists the [non-]relationship in the lower, grayed out section. I have been unable to figure out why some relationships work and some simply will not work. The field type? Do the files both have to be open and on a local computer? I haven't been able to find a document listing all the requirements.