Wednesday, November 28, 2012

Matchmaker, Matchmaker, Make Me a Match... To the Current Record Only

We just moved our FileMaker Pro 10 database to a new server. In the process, we switched from FM Server 10 to 11, but kept the FMP 10 database. Perhaps that's what caused the problem.

The Problem

A button that used to bring up a "Match Current Record Only" with the "Go To Related Record" command now matched the entire found set... no matter what setting GTRR was given.

The Solution

Layout 1 (with the button) and Layout 2 (the new window opened when the button was pressed) both referred to the same Table Occurrence (don't ask). So I created a new TO for the same table, and pointed Layout 2 to the new TO. (I also had to change the GTRR command for the button to point to the new TO and the same Layout 2.)

Matchmaker, Matchmaker, make me a match!
Find me a found set! Catch me a catch!...

No comments:

Post a Comment