July 25, 200520 yr Greetings, I have a solution for my photography studio. In it I have a portal that shows all of the sessions. Within each row there are check boxes to track its status 'in house'. Editting, at the lab, etc. Once the photos are picked up by the client, I would like for us to be able to click a 'hide' option within the portal that will simply drop it from the list... Is there any way NOT to show all of a related record set? That you could somehow have a field that would trigger it NOT to show up in the portal?
July 25, 200520 yr You just need a toggle field in the child table, Hide1,* a number field, with a Boolean value list (1); Field Format as a checkbox. In the main table, a Constant1, = 1, calculation field (number, can be Unstored, but you might want to leave it stored, to use for other things). Then add that to the portal's relationship, as another criteria (you can do that in 7), but as "not equals". Then, after clicking the checkbox in the portal, that record will vanish from the portal. You might want a short script to set the related checkbox, so it can Commit Records as the last step. Otherwise you'll have to click outside the portal to make it happen. *Alternatively you can use an Visible checkbox, which would auto-enter 1, then clear it. Either way.
July 26, 200520 yr Author Edit: Answered my own questions Works awesome! Thanks a ton :) Edited July 26, 200520 yr by Guest
Create an account or sign in to comment