Allow Table Queries to Filter Over Linked Record Fields

[John]

I’m creating a demo application that heavily uses linked records (screenshot below). In this example, I want to be able to create a table query that filters the procedures based on the recipe they’re used in, and then use an aggregation to sum the procedure times into a full cycle time. In theory, this table will be used to contain every procedure used in this baking operation. I would like to be able to filter by recipe (using a “contains” → app input operation) on the app end.

Right now, I can only apply table records to non-linked fields (see second screenshot).

[jboyle]

I just recently came across a similar situation. I was dealing with fewer linked columns and ended up duplicating the information in the link in an adjacent column to allow for the aggregation.

[John]

@jboyle, that’s what I ended up doing, too.