If you have a field that flags those not already enrolled, you can either use a new relationship based on primary key and the enrollment status field or simply filter the portal by the enrollment status field
Thanks but not quite how it works.
Students can enrol on various course 's
So what I need to do is show contacts who do not have a record in the table students on courses where the course Id equals that of the current record
it seems like you can then use the "not equal" as your relationship key instead of the "equal"
Good morning jamestebb,
I hope you had a wonderful weekend. I'd like to offer some assistance, if I can. Would it be possible for you to post an image of your relationship graph? Thanks and have a great day!
One approach (I'm sure there are many) would be to use a calc field in the people table to get a list of ids for a persons registered courses. Then use that field in your filter of the Contacts/People portal. This is relatively straightforward, but you will need to incorporate some scripting to refresh the window and flush cached join results when adding or removing from your roster. I've attached a sample file illustrating how this could work. If you are planning for 10s of thousands of records and/or deploying over the WAN this might not be the best approach, but you might want to rethink the basic design if that is the case.
I hope this helps.
Sample_CourseReg.fmp12.zip 81.1 K