AnsweredAssumed Answered

Go to related record failing

Question asked by IndigoHomme on Feb 2, 2015
Latest reply on Feb 2, 2015 by IndigoHomme


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.