I'm not quite following. Is Pqr in Table A? If so, its indexing and/or storage is not the problem.
If Pqr is in Table X, then, yes, it must be indexable. If it's in Table A, can you describe what happens, i.e., what you mean by 'it doesn't seem to be working'? If it's in Table A, you may be running into a situation where the the key can evaluate to null or empty, and that can break a TO. This was a change introduced in Filemaker 9 (the ESS release), in order to comport more with SQL rules. John Weinshel From: "Richard S. Russell" <[email protected]> Reply-To: FileMaker Pro Discussions <[email protected]> Date: Mon, 1 Dec 2014 03:28:34 -0600 To: <[email protected]> Subject: Creating a Relationship Using a Global Field So here in Table A I have a numeric field, Abc, and a global field, Ghi. Over there in Table X I¹ve got a numeric field, Xyz, an indexed decimal number. What I¹m trying to do is have a calculated field in Table A, Pqr = Abc + Ghi / 1000, link to Xyz. Obviously, Pqr can¹t be stored, because it relies on a global field for part of its value. Not being stored means it can¹t be indexed. Nonetheless, Xyz is indexed, and I thot that was all it took to establish a valid relationship. It doesn¹t seem to be working, tho. Am I missing something, or is this just not gonna work?
