Lookup for matching data returns false negative

[Getchi]

Happy Friday-

Does anyone have an idea why when I do a lookup to determine if an ID is the same in two databases, filemaker sometimes returns a false negative; i.e., filemaker says they don't match, but doing a "find differences" in bbedit shows they're identical??

Thanks

[Getchi]

Happy Friday-

Does anyone have an idea why when I do a lookup to determine if an ID is the same in two databases, filemaker sometimes returns a false negative; i.e., filemaker says they don't match, but doing a "find differences" in bbedit shows they're identical??

Thanks

[Getchi]

Happy Friday-

Does anyone have an idea why when I do a lookup to determine if an ID is the same in two databases, filemaker sometimes returns a false negative; i.e., filemaker says they don't match, but doing a "find differences" in bbedit shows they're identical??

Thanks

[-Queue-]

Are they of the same field type? Both must be text or num to match correctly.

[-Queue-]

Are they of the same field type? Both must be text or num to match correctly.

[-Queue-]

Are they of the same field type? Both must be text or num to match correctly.