I want to create a database with data from various sources.
Source ERP, that would be a Base db connected by ODBC to SQL Server (on SQL Server no foreign tables can be created).
User has to add some data to tables. I would like to offer the user a nice data-entry form in Base (Base db HSQLDB).
Create a Calc file which will contain all data from the previous 2 Base files.
A Base file which has the Calc file as datasource and will connect the datasources together and create a report out of it.
So with this solution, I need 3 Base files and 1 Calc file. That is quite a lot of files to create a report. Does someone have a better idea to solve this and use fewer Base files?
I hope my question is clear. Thanks.