At the University of Hartford, we have found that a single select with multiple joins is more efficient than multiple selects. We use multiple selects when the data selection requires it. Allan Geetter University of Hartford West Hartford, CT 06117 geetter@hartford.uhavax.edu