My reply might be mis-read. The command I gave,
>?USED('Member')
..is to
test for the table being in use, not to use it. I'm assuming here that you are running a .prg (since you referred to a "program"). If your tables are opened by a form instead, make sure 'Members' is in the DataEnvironment.
Mark
>Sounds like the table is not in use. You must USE it before SELECTing it. Try putting this before the SELECT command:
>
>?USED('Member')
>
>>I have just created a new table called member when I try to select the table in the program it says alias 'Member' not found. But if I use it in the command window it finds it. Why can't I select it but can use it.
>>
>>Select member - error
>>Use member - no error
>>
>>All my tables are in the same directory and this is the only table with an error occuring. Any ideas as to why it might be doing this?
>>
>>Thanks,
>>Tyler
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.