AnsweredAssumed Answered

Client Invoice Statements

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

Title

Client Invoice Statements

Post

Hello,

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,

invoice.jpg

Outcomes