Hi Everybody,



I have an issue i am trying to solve for the past week un-successfuly

I have a document with 3 sheets -
Sheet 1 - Display all Clients orders, and the order numbers and vale
Sheet 2 - Display all Clients Invoices, and Invoice numbers and value
Sheet 3 - Payments sheet, here is where i need your help:
i have the following scenario -
A. Choose Client name (From droplist) - no issue
B. Choose Document Type - Orders or Invoices (From Droplist) - no issue
C. Show the relevant Order numbers or Invoice Numbers (in a drop list) according to the Client & Document type - Issue!!!

I managed to get the entire Orders number or the entire Invoices numbers according to the Document type, but didn't manage to get the related numbers per client...

Would be more then Happy to get your assistance!