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

    Go to related record failing



      Go to related record failing


      FileMaker Pro



      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.