1 Reply Latest reply on Feb 2, 2015 11:31 AM by IndigoHomme

    Go to related record failing

    IndigoHomme

      Summary

      Go to related record failing

      Product

      FileMaker Pro

      Version

      13.04

      Operating system version

      OS X 10.9.4

      Description of the issue

      I have two tables - Tickets and Adjustments with a relationship that matches fields TicketNo AND AccountNo that exist in both tables . Both fields are numbers in each table.
      Go to related record (Match Current Record only) from Adjustment to Tickets matches all Tickets on AccountNo, ignoring the value of TicketNo resulting in a found set of over 600 Tickets.

      Expected result

      Error 101, as a Ticket record with values that match both fields does not exist.

      Actual result

      Ticket records whose TicketNo field matches the value of the current Adjustment record TicketNo field.