Multiple Find

[jasongodoy]

Hi everyone, in my solution I have this scenario:

My main detail layout has 3 different "Reference Fields" (these fields hold reference numbers for clients etc). I would like to have a find screen that lets the user enter a search term once, and when the user presses the Find button (my own creation, not the FM status bar button), have a script search each record in all 3 Reference fields for the search term they entered.

The problem I've encountered so far is that you can't set all 3 Reference Fields to the search term at the same time because not every record has the search criteria in all 3 Reference fields. If extend found set is the answer, how would I perform the same search if I introduced another search field (Project Number). So, at the Find screen, the user can enter a project number and a reference number field. How would a script find records based on the Project Number and be able to search all Reference Number fields and return results? Phew.....

I hope my description wasn't too confusing. Somebody pleeeeease help!

Thanks in advance.

Jason

[mr_vodka]

Jason, have a global field as the input field then either you can use extend found set or do it cimilar to the technique as in this post.

Multiple find criteria

[jasongodoy]

Thanks mr_vodka! Worked like a charm. Your help is greatly appreciated!

Jason