Client Invoice Statements
Newbie here so please be gentle.
I have a database with a table for clients names, a table with jobs, a table with invoices. I am trying to create a table for showing outstanding invoices, sorted for an individual client and in date order.
I create the relationship between the current tables based on clients name from a drop down list. I can get the table to show all the invoices ever created just not the ones that are unpaid.
Should I be trying to sort the invoice records in the invoice layout or am I going the right way round by creating a new table specifically for unpaid invoices?
Or if anyone knows a way of doing this even more elegantly I'd be pleased to hear from you.