i'm trying to create a database for my small business.
there are 3 tables in this database for now.
invoices
payments
invoices_payments (join table)
i have created a relation between them through a join table and it is working nicely till here.
now what i want to add is a new table for customers and allocate the payments manually as some of my customers send the payments together for few invoices and it might not be final amount so how shall i allocate this amount? for example if payment received from a customer for 3 invoices together then i will mention the amount received only once and there will be a portal showing the pending invoices where i can allocate the payment by hand for each invoice and the balance should keep deducting from the money received table.
any help would be appreciated.
thanks
kumar
