Find in one table, based upon field in another?
I'm trying to setup a button on the layout of my first table (Ingredients) that will run a script to find any records in my second table (Batches). The idea is that a user can click the button and find all the records in Batches that use/reference Ingredients. So far the closest I've been able to get is to having the script navigate to the Batches table, then perform a find, but it never finds any records. Any ideas of how to approach/solve this?
If you have a relationship linking ingredients to batches, don't perform a find, use Go To Related Records.
Set a variable to the value from the first layout's table.
Go to the batches layout
enter find mode
use set field to set up the find criteria, copying the value of the variable into the specified field
Perform your find.