Related Found Set Problem

[Veronica]

Greetings to All,

I have 2 separate files, a Staff file and a Student file. In selected situations I need to relate a certain kind of staff person to a particular student. I placed the related field for the staff person's name on the student layout, together with a button to perform a find for this certain type of staff person in the staff file. That part works. I get a found set of 6 individuals. But what goes wrong is that I get the entire staff listed in the "staff person's" field on the student layout. Isn't there some way to just list the found set? I've tried a bunch of things but obviously nothing has worked so far.

Thank you for your help.

Veronica :qwery:

[SlimJim]

Is your staff person's list in a portal on the student layout? (I guess it must be) To restrict to a found set you have to restrict the portal relationship so that the only staff people that show are the ones satisfying your criterion to be in the found set. This usually means adding in an extra condion into the relationship which defines the portal.

[Veronica]

Actually, no the field is not in a portal. There can only be 1 staffer of this type per student. My most persistent efforts have been involved in using a value list approach.

My script to find this particular staffer is begins in the Student file but calls a sub-script in the Staff file. After the FIND is Performed, I Halt the Script, whereupon it jumps back to the original script and file, (right?) and selects the Staff Person field. But where I'm expecting to get a list of just those 6 people, I get a list of the entire Staff file.

It makes me ask: Is there something wrong in the script, (Halt Script step)when it transfers back to the Student file? Or is there something I don't under stand about Halt or Exit Script steps that is having this effect?

Thanks for replying SlimJim.

Veronica

[comment]

Halt Script forces all scripts (including any sub-scripts or external scripts) to stop immediately.

If you want to script this, you should find the eligible staff, then Pause Script. You need a button to select the desired staffer. The button is defined to Resume Script. The script continues by setting a global to StaffID. Then go back to the student's record and set the AssignedStaffID field to the global.

Another way is what SlimJim suggested: define a relationship showing all eligible staff in a portal. Select a staff person from the portal by a button that sets the AssignedStaffID to portal::StaffID.