I have converted my embedded Philately database to a Split Database to try and ensure data integrity. I have managed to get it up and running relatively well with a couple of minor issues.
The first does not appear to be causing any issues yet, but whenever I open the database I get a Macro error in the “setup” macro telling me the Variable is not defined. I resolved that by disabling “Option Explicit”, though, in future I might want to fix that problem.
This one, however is needed to ensure data integrity:
I have discovered in use that the new tables do not have the unique flag set on certain fields. As I have about 30 linked tables and about 3000 records in the master table so far, I do not want to have to spend another 2 hours re-creating all the tables. In simple terms, please, (I am new to Base and even newer to SQL) how do I convert said fields in each table to a unique value. i.e. (pseudo codes) set field myField in table myTable as Unique?