You could try a view, with Send SQL updates.
>I've never tried to relate from one table into another through part of a compound index and didn't know if it would work. I'll have to experiment with this. Since my tables are so large I'm guessing that I could save time over creating a cusror as Tracy suggested. I'll try it both ways and see if there is a noticeable performance difference.
>
>Thanks.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.