Duplicate error while quering for payment % split

[David]

Hello, my name is David (access forum newbie) and I could use help with a query I'm stuck on:

I have a make-table that lists several financial credits and debits for many customers that do business with my work. The make-table info comes from a co-workers database. Each debit/credit is split by plant.

Credit Example: [Deposit1 - Total($100) - Plant1($30) - Plant2($50) - Plant3($20)]

Debit Example: [Payment1 - Total($20) - Plant1($6) - Plant2($10) - Plant3($4)]

I made a query for the make-table that groups credits/debits by customer name and shows a percentage for each plant based on how much of the cust. balance it's holding. So, now I have a query that shows what the plant split is per customer.

Payment1 is split across the plants by what was accrued w/ Deposit1 (30%, 50%, 20%).

My problem: The make-table lists multiple debits/credit entries but has no primary key and duplicate customer names (since a single cust. have many deposits/payments that sum as a customer balance). How do I take the make-table info and bring it into a query with MY table (which contains customer invoices that need to be paid by plant split based on the make-table customer balance info) w/o creating lots of duplicate invoices?

I don't know why the Access query is confused when my customer names match the make-table's customer names.

Sorry for the long winded post - hopefully this makes sense to someone!

 

[David]

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, "George Fry's" for my table). Now, this won't work if I want % splits for all customers on one page, but on an individual customer basis it works fine.