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...