rvfowler2
asked on
FM - How to Create an "Unmatched Filter"
Is there a way or a standard way of creating an unmatched filter in FM? It's easy in Access. Tried creating a TO as seen in the screenprint, but it showed all records. Now that we finally are able to import data from our DOS database into FM, I am trying to compare the manual entry of insurance Premium info with the Insurance Info that was imported from our DOS database. Typing "unmatched" in FM Help came up empty and "matched" didn't apply. Thanks.
-Unmatched.JPG
-Unmatched.JPG
The not equal should work, but you will have to think about the other conditions in the relationship. Not equal can cover a lot of ground if done incorrectly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm doing something fundamentally wrong because I made two fields equal to each other that had not matching records at all and still came up with 1715 records (or all of them).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, see the relationship in the screenprint above, but I was viewing it in table view and just assumed that it would be limited based on the TO. I have a long list of unmatched records. Can I view it in something like a table where I can scroll through or have to use a portal?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Close, but no cigar. When I used the RR and set the Relationships for Amount = InsPrem, it showed 344 records. Since the total recs was 404, I assumed a not equals would give me 60 records, which sounds about right. However, it only gave me 3. Attached are the RR and Relationship screenprints. Also, for what it's worth, FM really needs queries like MS Access. This is a ridiculous way to get unmatched data; I could have did it in Access in 2 minutes.
-Unmatched2.JPG
-Unmatched3.JPG
-Unmatched2.JPG
-Unmatched3.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, I don't think it is finding too many recs, just not enough. Its only showing 3 records. I put "Match All Recs" because I thought that is what you meant when you said you can use the GTRR to find ALL recs that are related to the main table. Again, my basic question is how do I create a list of all unmatched recs. This is REALLY weak in FM. We're going on 4 hours here and I could have done an unmatched query in Access in 2 minutes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks.