Hi,I have created a list view for my invoices (table Invoices). In the same layout, I would like to add a drop down menu with the list of my clients that would allow me to see the list of invoices for the selected client only.

I struggle to create this list (cannot use the Client_Name form my Invoices table), and to perform the find. Can somebody help me with that?

Thanks,

S.

Something like this example might be of interest. You can see it in action at:

Feb. '09 - Ergonomic Stimulus Award Winners

http://smallco.net/index.php/services

Thanks a lot for the example. It is useful! However I still cannot have the search performed. I have set up the script trigger and created the find script. But when I select a CLient or Job Number nothing happens, as if the find was not performed (all the records are still in the list)...

I have a attached a picture of what my layout looks like, and what my script looks like.

Thanks again for your help.

S.

Your search/trigger fields need their Storage set to Global, else they will have no value when you go into Find mode.

damned, that is simple once you think about it!

thanks a lot, all good now!

S.