About lookupsA lookup copies data from another table into a field in the current table. After data is copied, it becomes part of the current table (and remains in the table from which it was copied). Data copied to the current table doesn't change automatically when the data in the other table changes.To establish a connection between tables for a lookup, you create a relationship. Then you define a lookup to copy data from a field in the related table into a field in the current table.
• Copy data from a related table (which can be the same table) and keep it as copied, even when the data in the related table changes. For example, use a lookup to copy the price of an item at the time of purchase into an Invoice table. Even if the price in the related table changes, the price in the Invoice table stays the same.
•
• If you change data in the match field of the related table or in the lookup source field for a lookup, FileMaker Pro doesn't automatically update the data in the lookup destination field. To update the data, you must look it up again. This occurs when the value in the match field changes in the lookup destination table, causing FileMaker Pro to perform a relookup.