Chris C Posted September 13, 2007 Share Posted September 13, 2007 Hello! I am having a problem with filtering a portal. Here are my table relationships: case -- contact_linker -- contacts -- actual_contacts(client, attorney, witness, etc.) Those are my four tables in order... I have a portal on the "case" layout that looks into "contact_linker" and displays all the related contacts for that case... it works fine. But, I also have another portal on the "case" layout that looks into another T.O. of "contact_linker" in an attempt to show only 'opposing contacts'... The only difference in the relationships is an extra field called "Opposing_Counsel"... User's can click the checkbox for opposing counsel in the "contact_linker" portal if they want that specific contact to be opposing... the "Opposing Counsel" field for the "case" table is global and always set to "Opposing Counsel". This is what the other relationship looks like: case -- contact_linker_view_opposing (source table: contact_linker) Instead of showing the opposing contacts, my second portal only shows the first contact I ever created... It shows the same record multiple times as well (depending on how many contacts the user marked as "opposing") Any ideas of what is going on? It seems like it is really close to working correctly. Link to comment Share on other sites More sharing options...
comment Posted September 14, 2007 Share Posted September 14, 2007 Same as here? http://www.fmforums.com/forum/showtopic.php?tid/189987 Link to comment Share on other sites More sharing options...
iMarcW Posted September 14, 2007 Share Posted September 14, 2007 In my experience, when that happens, you have the relationship right in the portal setup but the actual fields are from another relationship (or table occurrence). Make sure you are pulling the fields from the same related table that you have the portal connected to. Link to comment Share on other sites More sharing options...
Chris C Posted September 18, 2007 Author Share Posted September 18, 2007 that was it! I can't believe I didn't realize that! thanks for the help! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6200 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now