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?
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.