Add the ability to create dynamic query inside the Geodatabase

[GuyNizry]

Like in MS Access queries with all the functionality to combine GDB tables\feature classes, add craeteria to filter subsets, Group By, Calculated field (base on other fields), ect.
Not static like it is now in 'make table query' tool (Arctoolbox), but dynamic (respond to origin tables cahnges).

[PiergiorgioRoveda1]

Hello! I use always MS Access and develop many apps for manage data of my features; I have create reports, automated and simple query and many other procedures... but It's possible that in ArcMap isn't so simple?
for example I generate a report with MS Access and I export it as image and this image I load in my layout... This isn't difficult and It's regular in my project, but it's unpleasant
An other procedure is most practise by me, the Calculated field base on other fields of other table (deco_table) like urban zoning specification area with volume and land-use... It's similar to use Model Builder, but there is many problem with join and temp files that are not implementing very well in Model Builder.
With Model Builder is difficult to create a Control Panel same as MS Access form...
On the finish... If i decide to select for need a FileGeodatabase (GDB), MS Acces don't see hom Data connect, and when my features-file size become 2gb I lost my ispiration.

Please Help for this content!

[SSWoodward]

This idea has been closed as a duplicate of the Data Management Idea linked below. Don't worry, you can still show your support by commenting and adding kudos to the open idea. Thanks for your contributions!

https://community.esri.com/t5/data-management-ideas/add-the-ability-to-create-dynamic-query-inside-t...