You are correct. Portal within a portal is not supported in Filemaker.
You can place fields from a related table in your portal, however.
Define a series of calculation fields that just return a number:
cVisit01 : 1
cVisit02 : 2
cVisit03 : 3
cVisit10 : 10
In Manage | Database | Relationships, use the button that looks like two overlapping plus signs to make multiple Table Occurrences of your Visits table.
Click your Visits table. Click the button and name the new TO "Visit 1". Click it 9 more times. (Filemaker will update the numbering for you.)
Link each of these TO's to the TO your portal is based on:
Participants::StudyID = Visit 1::StudyID AND
Participants:: ParticipantID = Visit 1:: ParticipantID AND
Participants::cVisit01 = Visit 1::Visit
Set this up for each Visit TO but substituting the appropriate cVisit field in place of cVisit01.
Note:: I'm assuming that a participant might be involved in more than one Study, hence the first pair of fields that match records by StudyID. If this is not possible, you can omit that pair of fields from the relationships.
Now you can place a related field from Visit 1 next to the participant name, a related field from Visit 2 next to that field, ... Etc. until you have the portal you wanted.
thanks for the response! I will try this out today and let you know how it works out!
I would prefer one relationship with multiple portals instead of multiple relationships. Each one line portal can start with a different initial row.
Since this is a display only purpose, another option would be to use a repeating field if you have a pre-defined number of trials such as 10. Here is an example.
Edit: Changed file host.
Once you go to that URL, hit the download button.
I was curious to see how the demo file works, but can't seem to down load it. I click the down load button and screen changes to show a code and a "get" button. I enter the code and click "get" only to get a new code showing with a new text for entering it.
I'm familiar with the horizontal portal technique that I think you are describing, but since our OP is describing a portal listing multiple participants, I don't quite see how that will work without sacrificing flexibility in the number of participants that can be displayed.
I'm picturing this interpretation of your post, where each bracket represents a different portal.
Which means that for 10 participants x 10 Visits you need 110 one row portals?!!
I must be missing something here...
Thanks Mr Vodka,
this is a great solution. Since i have some studies that have over 50 visits, this is an easier method to implement than creating 50+ TOs. Thanks for you help!
Yes I did mention the multiple 1 row portal method, but the example didnt showcase that. It uses a repeating field.
Strange about the website. Once you put in the code, it should give you a download popup... I can send it to you backchannel if you wish ( send me a PT if you dont have my email ). Speaking of which... When are they either going to move to a forum where we can attach files or else provide a means to do it.
Phil. I put it on another file host. Try it now.
Thanks for the clarification. Knowing that it's the repeating field approach (which is definitely easier to set up for large numbers of visits) removes my interest. I get that approach. It's only draw back may be any need to analyze the data stored in the repetitions. As always there are trade offs and its up to the developer to weigh the pros and cons.
I'd love to be able to upload sample files and screen shots directly to the forum. Sometimes there's just no substitute. Perhaps we should both wander over to the feedback forum and suggestion form to post that opinion?
It's only draw back may be any need to analyze the data stored in the repetitions.
Since this is a display only purpose, another option would be to use a repeating field if you have a pre-defined number of trials such as 10.