I am new to Panorama, having previously used database systems such as FileMaker Pro. Filemaker stores data in ‘tables’, such that one can set up one table with fields that show data from another table/other tables.
So I have a database with a ‘Words’ table that contains words from many languages, each word in its own record. Within each record are fields that contain various pieces of info. These include the name of the language the word belongs to, the language group the language belongs to, etc Since these bits of info are repetitive (because many words belong to the same language) they are stored in a ‘Languages’ table. A language_ID in each record relates the ‘Words’ table to a ‘Languages’ table, so that several field in each record in the ‘Words’ table show info that is stored in the ‘Languages’ table.
If I understand correctly, Panorama X uses a separate file for each table, and data are copied from table to table rather that data in one table being viewed in another.
Have I understood correctly? If so, what is the most straightforward way to emulate such a situation in Panorama X?