Chuck;

Your code - in part -

SELECT auth
SET ORDER TO authtype
Seek
Etc.

SET ORDER TO main
SELECT authtype

Did you mean to open main after SELECT authtype? I see no need to open an index at the second to last line. Is that what you intended? Again, just interested.

Tom