2 Replies Latest reply on Feb 4, 2013 2:22 PM by philmodjunk

    Portal Question

    MaxwellRobin

      Title

      Portal Question

      Post

           Hi All!

           I have a table that I am using as a contacts list.

           I have another table that has a portal, which refrences the contacts table.

           In the contacts table there is a field for the contacts title.

           Multiple contacts can have the same title.

           Is there a way to exclude contacts with the same title from the portal?

           Or just include one of the multiple contacts with the same title?

           Does this make sense?

            

           Thanks!

        • 1. Re: Portal Question
          schamblee

               Portals are based on table occurance, which basically is the realtionship.   You would have another relationship matchomg your current table occurance  with title = GlobalTitle added and another occurance  with title ≠ GlobalTitle added.    GlobalTitle would be a global field that you select the title you want to match or not match.

          • 2. Re: Portal Question
            philmodjunk

                 It would help to know the exact relationship you have set up for your portal's relationship. Lacking that, I'll name the two matching fields as PrimaryKey and Foreign key. You could set up this set of tables and relationshps:

                 Layout'sTable----<Titles-----<Contacts

                 Layout'sTable::PrimaryKey = Titles::ForeignKey

                 Titles::__pkTitleID = Contacts::_fkTitleID

                 Then you can place a portal to Titles on your layout, but include fields from Contacts in the portal row. Your Title field would be defined in the Titles table, not Contacts.

                 If the above notation is unfamiliar, see the first post of this thread: Common Forum Relationship and Field Notations Explained