On Jan 1, 2009, at 12:36 PM, Gary Hunt wrote:
I still consider myself pretty new at Filemaker. What I really want to do is create a Union query of similar subsetted information from about 20 tables. However, I understand Filemaker does not support “Union” Queries.
It's not the union query FMP doesn't support per se but rather the dynamic table to contain the results of the query. Depending on your relational structure you may be able to approximate a union join in FMP although not dynamic attribute aggregation nor dynamic record creation.
My first question is "20 subsetted tables?" I'm fairly familiar with entity types and subtypes and have yet to find a situation where I would have 20 subtypes for an entity class. Why so many tables?
Second, if these are subsets then that presumes there is or could be a table for the superset. Why not perform the query there?
Cheers, -corn Corn Walker The Proof Group http://proofgroup.com/
