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?