If you have a global field that is strictly for the purpose of facilitating a UI feature, you might define a local table of global fields in your UI file. I they need particular default values, you can set up a script to load these fields when the file is opened.
For changes to the Data side that can't be avoided, you have two options:
- Wait until no one is using the system, and modify the working copy directly. This is often a convenient way to make small changes.
- Write a script in your data file that imports all the data from all the tables in the current data file and then updates the next serial value settings to your script. With this script, you can click a button and import all the current data into your new file, then swap out the files.
I guess it's more or less the "manual way" then. The importer script sounds nice... although it scares me a bit that something could go wrong and leave me with missing data.
Hopefully I wont have to make many alterations to the initial schema.
Thanks and regards,