Confounding relationship problem-Global to number
I've done this many times before: A global calculation field calculating as "1" in table one matched to a number field in table two. Any records in table two marked "1" will be accessible from table one via this relationship.
I'm trying to do this again today and am totally perplexed as to why it's not working. It's basically ignoring the match fields. From table one I am getting ALL the records in table two. The only thing that has solved this has been to turn my global calc field in table one into a number field and auto enter "1".
I know there's not as much to go on without seeing an example, but can anyone thing of a reason why this is occurring?