I've been away from Filemaker since FM5 and am now running FM8. I used to be able to use LOOKUP to get information from database "A" and populate database "B". It doesn't appear that FM8 will let me do this. The situation is that I have a few reference files such as ZIP CODE that will return geographic information based on a zip code entry (a big time saver on data entry). It doesn't make sense that I would have to include full copies of these files in each of three different databases that need to have access to this information. When I attempt to use the LOOKUP function, the dialog box only presents the tables that are related to the database that is active at that time, not allowing me to gain access to the ZIP CODE database.

So how do I lookup data in records located in a FM database other than the currently active database?

Thanks.

See Help > Working with related tables and files > Working with the relationships graph > Adding tables to the relationships graph.