Hi all,
There are two different databases in two different offices controlled by two different teams. I work in one office with a team that inputs certain parts of the data into a LO Base database and we use the reports feature to make great looking prints from the data. The other team uses MySQL and has a table that has some shared fields to what we have but not everything. Instead of duplicating work, I’d like remove those fields from our database (since we copy what the other team does anyways) and make a query that joins a view from the MySql database with the data from ours so when I run report all the updated infor nation is compiled.
Is this possible? If so, how do I set this up?
Many thanks,
Jon