I think what I want is a self join relationship displaying information in a portal. I have a very simple database of committee members that I want to do one specific thing with. As I complete a record, one of the fields is "Committee Membership" and it indicates with committe the person is a member of. There are about 20 committees each with about 20-30 members. I would like to add a portal that shows all the other members of the committee when you are looking at a persons record. Ideally, i'd even like to be able to click one of the other members to go directly to their record to view detailed info.

Is a portal the right tool?

Thanks!!

the portal is absolutly the right tool. once the self join is set up relating the committee to committee, you can use the go to related record script step to click on a portal row and go to the that individuals record.