You will need to create three relationships which filter the portals accordingly. There are two ways of creating relationships based upon alpha ranges: use a multiline calculation of each letter or use comparative operators. I've create a sample which shows both ways.
The multiline multiline example creates calcs tab1, tab2 and tab3. I placed them inside tab panels. The second example uses comparative operators (the calculations are i and r).
This is perfect, thanks. I found something similar in a book, but it really did not explain it as weill.
Thank you again.
I just wanted to add something that I did, which seems to have replaced the need to create the extra calc fields and relationships.
I have the Clients Table with a self-join to show all records with a global text field that I have joined as well. Whatever I put into the text field appears in the list, A shows only A names, etc. Instead of adding the calc fields and relationships, I used what i currently had and just created a script that runs when I click one of the tabs. I use an If Else If statement to see what tab is in front, depending on which one is selected, I have the script fill in the global text field with a range of letters, ie. "a¶b¶c¶d¶e¶f¶g¶h". Then the portal only shows that range, and each tab has a different range.
I would not have figured this out without the example you posted, I appreciate it.