Hi Bill I can't see users selecting 300 users, there must be another criteria that they choose to get those clients, can't that be used instead.
Otherwise: I would set up another file "SELECTEDCLIENTS" with key @UserNo*Clientno with f1 = 1 which holds the clientnos the user wants. The core subroutine builds that file. Then instead of using clientno = ..... in your selects use a TRANS(SELECTEDCLIENTS,@userno:"*":f2,1,'x') = 1 If it is not on SELECTEDCLIENTS it will return "" and only those items on SELECTEDCLIENTS will be selected. It is just an idea, and processing may be faster. Regards David Jordan Managing Consultant Dacono Holdings Pty Ltd ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
