>>Right now, I'm trying to get it to work as a view, because I need it updatable. The view designer can't seem to handle the same table twice, so I need to figure out all this update stuff by hand.
>>
>>Thanks,
>>
>>-Michelle
>
>i would have suggested using locations twice...

I do use it twice. But for some reason view designer will allow it, but then crash next time I try to open it.

Thanks,

-Michelle