1 Reply Latest reply on Mar 7, 2013 12:19 PM by philmodjunk

    Refresh/Re-lookup Script



      Refresh/Re-lookup Script


           I'm new to Filmaker and am currently running version 10. 

           I'm trying to write a script that will refresh the look-up for all the product item numbers with a specific record.   Each record is a kit (kit item number) that is made up of a number of products.

           The product item number is the trigger to look up the cost for that particular item. 

           I can get the look up to happen accross all the records in the data base, but I can not get it to run the look up just within the individual record.

           Can anyone give me some suggestions as to how I can make the relook-up happen accross all the item numbers within one record?

        • 1. Re: Refresh/Re-lookup Script

               The re-lookup should only take place for all the records in your found set, which may or may not be all the records in your table.

               Perform a find for only the records you want to do this re-lookup and then try the re-lookup.