>>>>I know there is some way of putting this on one line using IIF (I think), but I just can't recall it right now. Thanks!
>>>>
>>>>
>>>>IF NOT USED('Schedule')
>>>> USE Schedule IN 0
>>>>ENDIF
>>>SELECT Schedule
>>>>
>>
>>Ok, I thought there was a one-line way of doing it, but maybe not.
>
>Probably better than Torre's as it is not reopening a table when it is already opened:
>
>
USE (IIF(USED('Schedule'),"","Schedule")) IN 0
>
>
>Walter
That's the one I was looking for. Thanks!