I have four old fmp 6 databases that I have converted to 8.5. Now I'm trying to establish relationships between them, but I cannot figure out how to add each database/table to the Tables window for each database. I assume I need to have each database/table listed in the Tables window in order for them to be used in the Relationships window. The current name of each database are; Customers, Invoices, Products and Salesmen. Each database already has primary/key fields, and lots of data. Thanks!

I assume I need to have each database/table listed in the Tables window in order for them to be used in the Relationships window.

No, the tables listed under the Tables tab are local tables only. To establish a relationship to a table in another file, select the Relationships tab, click the "Add a table to the relationships graph" button and choose the file/table to add.

You can also import the other tables into a single file and eliminate the other files.