I have a FM7 database that I use to track an investment club stock portfolio. There are four tables: ClubAssets, Stock, StockTransactions, and StockPrice. In one of the Stock table layouts, I display the stock's current price, which comes from the related record in the StockPrice table. I update the StockPrice table by first deleting all old records, then importing a tab-delimited file downloaded from the Internet, using a script. After the new prices have been imported, the price shown in the Stock table layout is still the old price. I have to move to the next record and then back to the original record to force the price to update. Is there a way to tell FileMaker to perform this re-evaluation from within my import script or by some other automated means?
Thanks in advance for your help.