Lookup fails when relationship is two hops away

Discussion created by deanchampeau on Oct 6, 2016
Latest reply on Oct 7, 2016 by philmodjunk



I have a table (Estimates) that is related one-to-many to a second table (Estimate Requests), which is related many-to-one to a third table (Customers). When I enter a value into my match field in Estimates, it populates my lookup fields as I would expect, but ONLY those fields where the lookups point to the child table (Estimate Requests). Fields where lookups are defined as coming from the grandchild table (Customers) do not populate. Is this a limitation with FileMaker, or am I not doing something properly?