Identical portals: one working, one not!
My situation is this: Using FMP v10, with Server 10... three hosted solutions to build assessments. One is a centralized file with multiple tables (call it Base), and there are two "interface" files (call them A and B) that access the Base tables to create and manage the data. Files A and B provide navigation and relationship keys via global fields, no real data.
I cloned File A to create File B, so the structure and relationship diagrams are identical (basically modified the look-n-feel, plus some scripts that set IDs, etc.).
On one layout in each file, a local global field is meant to contain the key value into a Base table. When that global is set, the four related records from the Base solution display in a portal. This was all working just fine last week. All of a sudden... this portal in File A stopped working!! When the global is set, nothing displays, altho the underlying data is absolutely there.
The most baffling thing is that its identical "partner" portal in File B works as always. I have combed the relationships, the fields, the scripts. Everything appears exactly the same. I have recreated the relationship multiple times and still cannot figure it out.
Is it possible that there is some sort of conflict going on here, with both files accessing the Base table?? Please help me troubleshoot why this is happening, as I have many users waiting on the answer!