I have the following MySQL Schemas:
They have the same tables and corresponding structures. I have a report that calls a stored procedure that pulls the data for the report. I designed my report using Branch01. At runtime, the user may select Branch01 or Branch02 or Branch03, depending upon the given situation. However, my report still calls the data of Branch01.
How to work around this? I am using MySQL and Xojo.