Update field with contents from another unrelated file

[jjfcpa]

I have a file that contains data as a result of an import of XML data. I need to copy some of the data to another unrelated file. They do have a common field between them and I want to find the record with the same data in that field and copy some data that was imported to that table.

For further clarification:

Common field is: stock_symbol

Import table: data imported

Investment table: contains stock data

The imported table has stock data in it. I need to look up the stock symbol found in the import table in the investment table and copy some of the imported data to it.

I need something like the Lookup() function for an unrelated table.

[comment]

See "Updating matching records" here:

http://www.filemaker.com/11help/html/import_export.16.11.html#1027964