Solved

FM - Portal Filter Help

Posted on 2011-02-15
5
912 Views
Last Modified: 2012-05-11
I've got this to work in another db, but not in this layout.  Filtering by County and Town work fine, but as soon as I add the more complex ones of filtering by Price or by BusinessType1, no records show when all global fields are empty (when all are supposed to show), and when you select a Price or BusinessType from their respective drop-down selection, nothing happens.

-Portal1.JPG
-Portal2.JPG
0
Comment
Question by:rvfowler2
  • 3
5 Comments
 
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 100 total points
ID: 34896920
I would start by checking your calculation key fields by putting them on the layout as regular "Edit Box" fields so that you can see them and make sure they are actually calculating to what you think they should be.
0
 
LVL 12

Accepted Solution

by:
North2Alaska earned 400 total points
ID: 34897514
Also, confirm that the fields you are relating to are indexable.  I get bit by this quite often where I have a calculation field that can't be indexed.  You can not use a non-indexed field on the right side of the relationship.
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34899181
Will, thanks for the tip; makes it simple.  Alaska, yes, you taught me about indexing once before, but I had forgot it.  That cleaned up most problems, but I have one more that I've never seen.  About half of my records do not show any portal records, even though the count field shows the correct number.  Never seen this or heard of this one.  I even tried relating the table by only one of the four portal fields, cycling through each one and obtained the same result.  Half of the records show no portal rows.
-Portal1.JPG
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34899249
As soon as I posted, went back and figured it out.  I had copied this portal from another layout and changed all the fields, but forgot to change the filter, which had the portal record not equal to the record of the main layout, so that the record one is on does not show as one of the portal rows.  But, of course, needed to change the table and field names.  Thanks.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 34899252
Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question