AnsweredAssumed Answered

Client Invoice Statements

Question asked by NevilleHornsey on Nov 15, 2010
Latest reply on Nov 16, 2010 by philmodjunk


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.

Best regards,