How do you uniquely identify each invoice? I suggest adding a pkInvoice column in the invoice table. id is a bad field name. I suggest pkCustomer and fkCustomer. I found it helpful if fields used for joining tables to be unique in the database.