Newbie find problem

[Symont]

Ok, I'm new with FMP so this is probably something simple but I just can't find a solution.

I want to create a layout to find records from different tables. I'd like to be able to do more than one find request at a time. How can I transfert two fields in browse mode (research fields) to two other fields/requests in find mode of another table and layout?

Thanks

 

[TStriker]

Symont,

You might want to read up on global fields. These fields act like variables that last for the duration of the user session. If you are in a multi-user environment, the global fields are workstation specific. This concept is difficult to get past for new FM developers but the workstation specific nature of globals can be put to good use in a situation like yours.

If I understand your request what you should do is create your "search" layout with global fields. I like to label them something like Temp_Text_01, Temp_Text_02, etc. because you can easily reuse them for other things. The user would enter their search criteria into the global fields. You would then create a script that have these general steps:

1. Switch to the results layout.
2. Enter the find mode.
3. Use "Set Field" to set the field that you want to search with the vaule in your global field.
4. Perform Find.
5. Maybe pause here or just simply end here.

You should now have a set of found records that match your search criteria. To search the 2nd table you would repeat the script but use a different layout.

Am I missing something?

-Striker