When you first open a database you will see a menu at the top listing the tables designated as main tables. If the web page is too narrow or there are too many main tables then only the first few tables will be listed. The remaining tables are found under one of the following dropdown menus:
- Main: If the web page was too narrow then this menu will appear listing all of the Main tables in alphabetic order.
- Lookup: The lookup menu will appear if there were any tables marked as lookup tables.
- System: Admin users may also see a menu named System which will contain all tables that were marked as system tables.
You can use the Database Preferences to manage which tables appear in which dropdowns and to set the order of the main tables in the top menu.
You can also specify a Startup View in the database preferences. The Startup View determines the default presentation when a database is initially opened.