>>>Locations is where the "word version" of the keys ipickup and idropoff come from. That's the one that's giving me the most trouble right now.
>>>
>>>Thanks,
>>>
>>>-Michelle
>>
>>lockey is ipickup and idropoff?
>
>ipickup and idropoff are foreign keys, both representing a (usually) different lockey in locations.
>
>I got the SQL working using just one join, and specifying the rest in the where, but I don't know how efficient that is.
>
>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...