Create custom search menu in list

[thezed]

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.

[Fitch]

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

[thezed]

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.

[Fitch]

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

[thezed]

damned, that is simple once you think about it!

thanks a lot, all good now!

S.