my setup is an .odb file where I enter all data into a form to populate the database. I work on various cases and use a new database (.odb) file for every case (since I never have to send mass-emails or something like this). I just want to populate various .ods and .odt files with case-specific variables, but only enter them once. So I figured to create a database for each case and retrieve the values from the database in all the case-related .ods and .odt files.
I know how to add the base file as a data source, but how can I tell Calc to automatically retrieve the value from the database? I have lots of columns in my database file, so manual entry by drag&drop is not really an option. For example, I want calc to populate A1 with the string in the first (and only) entry in the column “Name” of the connected database.
Same goes for .odt, there I would like a string like "Dear Mister ", where is populated with the data entered into the “Name” column in the connected database.