https://legacy.forums.gravityhelp.com/topic/ms-access-and-multiple-tables Gravity Support Forums Topic: MS ACCESS and multiple tables en-US Sun, 19 Apr 2026 18:25:35 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/ms-access-and-multiple-tables#post-169646 Wed, 13 Mar 2013 06:49:00 +0000 Chris Hajer 169646@https://legacy.forums.gravityhelp.com/ <p>This is outside the support we can offer here in the Gravity Help support forums. Sounds like you are on your way by allowing external connections to your MySQL database from Access. The UNION and SQL support is something we can't help you with. There are many resources online for help with SQL though. Here is one: <a href="http://www.mysqltutorial.org/sql-union-mysql.aspx" rel="nofollow">http://www.mysqltutorial.org/sql-union-mysql.aspx</a> </p> https://legacy.forums.gravityhelp.com/topic/ms-access-and-multiple-tables#post-164820 Fri, 08 Mar 2013 17:17:00 +0000 Mattingly Graphics 164820@https://legacy.forums.gravityhelp.com/ <p>I have a client who has forms for user submission. The end target is Access... sort of. They don't need access as a database, but rather for querying and producing reports. The exported CSV adds a few extra steps, and we haven't been able to develop a workflow which allows allows them to simply export new entries, and have them properly import into access, purge for duplicates, etc...</p> <p>So I'm in the process of simply allowing Access to connect to the MySQL database tables for the RG_Leads tables. I can get in just fine, and the tables pull down great. But there are 3 of them. Now I need to run a Union query to pull the necessary data from the three different tables and populate a new table with that data.</p> <p>Has anyone had experience doing this? Any guidance or suggestions?</p> <p>Thanks! </p>