It appears you want a script to 'Find' certain records, based on 2 parameters of user input. You don't say which version of FM you are using.
There are a couple of ways. Easiest would be 2 global search fields on the layout and a search button. Each field would be tied to a value list, so the user can only select existing values (if preferred). The button would gather both criteria and perform a search. Better would be both dropdown fields, and a conditional value list, so after the user selects the field, then the next dropdown would only show crops from that field. The find script would perform the find, change layouts (I assume based on the same Table or Table Occurrence).
So Method 1: 2 dropdown global fields, value list & conditional value list (add a table occurrence), script and layout.
Little better would a popover or modal window to gather the search criteria, perform the find, if records, then go to new layout.
If you are unfamiliar with conditional value lists, scripting, etc., it may be best to post a sample file for someone to modify
Thank you for the reply. I am using FileMaker 14
Do you mean post over the whole DB ?
Did you find your sollution?
Maybe you can try use self relationship... something like that:
- create a text calculation field (table::FieldName & table::Crop_Code);
- create a self relationship on "table";
- create a list values based in the relationship.
Marcio Nunes Ferreira.