I am having trouble with a trying to roll fields from multiple tables up into one ""overview"" table.
I have an app with two local tables and two connected tables .The connected tables pull data from a separate QB app. I want to create a table that incorporates some fields from each of the other 4...
It is non-intuitive that the field "gets used up" once used as a reference field on the right side of a relationship and that you need to do that cheat.