I'm a newbie in the GIS world and I have few problems dealing with connections between my Filemaker database (version11, .fp7) and ArcMap.
I could connect it to ArcGIS without problem trough an OLE DB connection and now the different tables appear into my content. But of course, all the relationships (one-to-many) disappeared.
Now I would like to do selections by attribute using fields of different tables. Let's say I have a table with natural sites and their attributes, an other with the animal found on these sites and their attributes, and a shapefile with polygons of the sites.
How can I select, for example, the sites that where protected after 1980 and where we found white wolve?
I can do that with Make Query Table, it worked, but I have a lot of datas and the resulting table start to be too big. Is there any way to keep the one-to-many relationships between the tables and to make an SQL statement?