table switching in a layout:
FileMaker 10 (and several versions before, but after 6) have the ability to contain several tables in one file. Can I use the same layout (1 and only 1 layout in 1 and only 1 database file) to show records from 1 of multiple tables, (but each table has the exact structure from the other) without using portals?.
The reason is I'm using several FileMaker Pro V6.04 databases to keep track of actions and dates. The main database is the active one, but once a record reach a milestone and the information is recorded, I manually transfer the record to what is called an inactive, closed or archive database (each one is a different database) so that my files doesn't get bloated.
What I want to know is, if it's possible to use only one layout to show the records of different tables (no portals) by, let's say, selecting an option in a pull down (Active, Inactive, Closed, Archive) and triggering a script to change to the table with that name.
Thanks guys, great work.