Go to related record failing
OS X 10.9.4
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.
Error 101, as a Ticket record with values that match both fields does not exist.
Ticket records whose TicketNo field matches the value of the current Adjustment record TicketNo field.
Problem solved - wrong table and view name (blindness on my part). Apologies.