Calculation in Portals
I have a table that is a list of Members. It has a keyfield "MemberID," there is a field in the same table named "sponsor." For each record, the "sponsor" field contains the "MemberID" of the person who is the Sponsor of that member.
I have a layout that shows all of the information for each member - broken into tabs - with a portal on one tab that I want to show a list of all of the members the Record Member sponsors. But I can't seem to get it to work and I cannot figure out what I am doing wrong.
I do have another tab in that layout with a portal where I was able to show all the Groups a specific Member sponsored ... but the groups are in a different table, and it was fairly easy to have it work.
I am totally teaching myself as I go here ... so I'm sure I can't see the forest through the trees! Any help would be appreciated.