Nevermind, I found a solution.
If anyone is interested: since Access was confused which customer balance percent split it should pair with each invoice, I simply pulled in the "Customer Name" fields from both tables and entered a specific name for each (ex. "George Fry's" for make-table...