I'm developing an employee training registration file. I have a portal listing all [color:blue]classes selected by an employee, and a portal listing all [color:red]available classes. My question: How do I remove the [color:blue]classes already selected from the [color:red]available classes portal.

After all you can not register for a class that you have already registered for, so I do want them to be able to see it in the available classes portal.

Edited March 13, 200619 yr by Guest

I'll assume that your portals are on a layout based on Employees.

Create an additional field in Employees that you can use as a key to your Available Classes TO. Add to the current relationship between Employees and Available Classes like so: Employees::NewField :notequal: AvailableClasses::classID.

Then use a script to select classes. When a class is selected, have the script set this new field to its own value plus a carriage return plus the ID of the class that was just selected. You'll end up with a carriage-return separated list in that new field, showing IDs of all the classes that have already been selected. Make sure you have a script to remove classes that undoes this action or you'll end up with classes that are neither taken nor available.

Hope this makes sense and helps!

Worked great.

Thanks