I’m trying to either filter across tables, or link records across views. From what I’ve seen so far in the tutorials, it’s only possible to filter on local columns or the key column from a linked table. Say that I have an address table and a name table, where there is a many to one relationship between addresses and names. Before I link the two, I only want to include the active addresses, so that my final view has a one-to-one relationship between address and name. But, once in the ‘names’ table, I can’t filter on the ‘active address’ field from the address table, though both tables are linked. The solution that comes to mind is to create a view of active addresses first, and then link this to the names table, but I can’t seem to do this either. Does anyone have a good workaround for this?